PhotoPlog

Go Back   PhotoPlog > PhotoPlog Lite > Troubleshooting & Problems
Screens Demo Purchase Download Register

Closed Thread
 
Thread Tools
  #1  
Old 04-17-2008, 06:57 AM
doogie88 doogie88 is offline
Green Plog
 
Join Date: Feb 2007
Posts: 14
Gallery: 0
Comments: 0
Default PLEASE HELP

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.
  #2  
Old 04-17-2008, 04:25 PM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

PMs/emails are not meant for support. If I didn't write that to you in PM, sorry.
Code:
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:
Code:
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.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
  #3  
Old 05-05-2008, 04:18 AM
doogie88 doogie88 is offline
Green Plog
 
Join Date: Feb 2007
Posts: 14
Gallery: 0
Comments: 0
Default

Do I just add empty tables? OR what do I do with those 3?
  #4  
Old 05-05-2008, 02:02 PM
Morgan's Avatar
Morgan Morgan is offline
Head Plog
Admin
 
Join Date: Dec 2005
Posts: 5,324
Gallery: 10
Comments: 25
Default

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.
__________________
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Closed Thread

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:40 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.