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.
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.