PDA

View Full Version : PLEASE HELP


doogie88
04-17-2008, 06:57 AM
I have pro, but guess it's only 1 year access...

I have a small issue.
My server crashed and I lost most my data. The forum was backed up, so I resintalled it, and photoplog was still installed. So today I reuploaded the photoplog files, and all seemed to work, so when I went to edit permissions of users so they can access the photoplog dir, I got this error:

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'VIP Members',
`description` = '',
`usertitle` = 'VIP MEMBER',
`opentag` = '<b>',
`closetag` = '</b>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`forumpermissions` = '784375',
`genericpermissions` = '203953795',
`attachlimit` = '5000000',
`pmquota` = '120',
`pmpermissions` = '1',
`pmsendmax` = '5',
`calendarpermissions` = '1',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericoptions` = '41',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`signaturepermissions` = '232001',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`photoplogpermissions` = '4289',
`photoplogmaxfilesize` = '',
`photoplogmaxfilelimit` = ''
WHERE usergroupid=9;

MySQL Error : Unknown column 'photoplogpermissions' in 'field list'
Error Number : 1054
Date : Monday, March 24th 2008 @ 01:15:29 PM
Script : http://steroidworld.com/forums/admin....php?do=update
Referrer : http://steroidworld.com/forums/admin...&usergroupid=9
IP Address : 24.77.249.12
Username : admin
Classname : vB_Database


Any idea on what I can do instead of having to reinstall and upload everything? I have about 1200 pictures, so I hope I don't have to redo it all.
-----------------------------
You said:
Reinstating the vB tables is not enough. You need to also reinstate the PhotoPlog tables.
-------------------
I don't know what that means, and you don't reply to PMs anymore.

Morgan
04-17-2008, 04:25 PM
PMs/emails are not meant for support. If I didn't write that to you in PM, sorry.
Content visible to registered users only.
That means the photoplogpermissions field does not exist in the vB usergroup table. Whatever backup you used did not contain the PhotoPlog fields so you'll need to add them to the vB usergroup table:
Content visible to registered users only.
Understandably you want support, but pro support and download access last for a year. If you need help adding those fields, perhaps your host can do it for you, or you could use phpMyAdmin to do it.

doogie88
05-05-2008, 04:18 AM
Do I just add empty tables? OR what do I do with those 3?

Morgan
05-05-2008, 02:02 PM
Not tables, fields in a table, though again, it is understandable that you want support, but your pro support and download access expired in February. If you want to renew, the fee is $35 for another year of support and download access. If you do not want to renew, you will need to find someone, perhaps your host, someone on vBorg, or you could use phpMyAdmin, to add those fields to the vB usergroup table.