getting strange errors

[DefenceTalk.com]

I am getting some strange errors on our PP:

http://www.defencetalk.com/pictures/

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT *
FROM vb3bbcode;

MySQL Error : Table 'defence_gallery.vb3bbcode' doesn't exist
Error Number : 1146
Date : Sunday, October 16th 2005 @ 11:22:32 PM
Script : http://www.defencetalk.com/pictures/...php/photo/8295
Referrer : http://www.defencetalk.com/pictures/index.php
Classname : vb_database

and

Database error in vBulletin 3.5.0:

Invalid SQL:

UPDATE vb3session
SET lastactivity = 1129519372, location = '/pictures/showphoto.php/photo/8295', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'f6a0d0c53618541bb63ed5e403d172a1';

MySQL Error : Table 'defence_gallery.vb3session' doesn't exist
Error Number : 1146
Date : Sunday, October 16th 2005 @ 11:22:33 PM
Script : http://www.defencetalk.com/pictures/...php/photo/8295
Referrer : http://www.defencetalk.com/pictures/index.php
Classname : vb_database

please help, thanks

[DefenceTalk.com]

I really need some help with this. Was PP package updated recently? within past week?

[Chuck S]

Our product was updated weeks ago with the fix to be compatible with vb35

I would suggest downloading the build and reuploading all template files and main php scripts except the config files

[DefenceTalk.com]

Thats what I am using and did not have any problems until yesterday.

[Chuck S]

You getting these errors by email or on screen?

I would reupload the files just in case as I run VB and don't get these errors. Looks to me like your pp-inc.php file is not the latest if your having these errors.

[DefenceTalk.com]

thanks,

i replaced the files and now this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxx/public_html/pictures/pp-inc.php on line 208

Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/pictures/pp-inc.php on line 2885

Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/pictures/pp-inc.php on line 2885

Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/pictures/pp-inc.php on line 2885

Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/pictures/pp-inc.php on line 2885

Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/pictures/pp-inc.php on line 2885

Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/pictures/pp-inc.php on line 2885

categories have disappeared on the main page as well!

[DefenceTalk.com]

I ran the upgrade script as well and got this:

Preparing to update database...
Error performing MySQL command: CREATE TABLE pics_cache (id tinyint(1) NOT NULL default '1', timestamp int(15) NOT NULL default '0', statscache mediumtext, recentcache mediumtext, popularcache mediumtext, randomcache mediumtext, calcache mediumtext, catcache mediumtext, catprops mediumtext, PRIMARY KEY (id), KEY id (id)) TYPE=MyISAM
Error: Table 'pics_cache' already exists

Error performing MySQL command: INSERT INTO pics_cache VALUES (1,0,null,null,null,null,null,null,null)
Error: Can't open file: 'pics_cache.MYI'. (errno: 145)

Error performing MySQL command: INSERT INTO pics_settings VALUES (211,'Minutes to cache index page data for featured photos, statistics and PALs?','cachetimeout','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)
Error: Duplicate entry '211' for key 1

Error performing MySQL command: INSERT INTO pics_settings VALUES (212,'Show Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)
Error: Duplicate entry '212' for key 1


Upgrade complete! You may now remove the upgrade.php script

.

[Chuck S]

See you never did your upgrade it looks like and your pp-inc.php file was indeed old so your not running the 3.5 compatible photopost

I would make sure you double check you truly have 5.2 uploaded.

Make sure you are running all 5.2 files and run the upgrade script to create the new cache table and other needed files.

[Chuck S]

Okay we posted at the same time.

Did you run other needed upgrades? Looks to me like you needed to run others than just 5.11-5.2

Your missing fields so thats why the query is failing

[DefenceTalk.com]

Well, this doesn't make sense. I upgraded all of the previous PP versions and the latest I performed was around october 6th-8th.... and there were no issues or anything until last night so if it was the upgrade wouldn't it have happened before?

[Chuck S]

well the only thing would make sense if possibly your server got rolled back to a previous install database and files by your host.

View your database does your cache table exist? Is there anything in it?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/defence/public_html/pictures/pp-inc.php on line 208


If there is nothing in it then it would seem to me the query to add the cats info to the cache table is failing here.

[DefenceTalk.com]

It still has files from 10/10/2005 so that's out of the question. If there was a roll back, I would know about it.

even when i try to upgrade from the previous versions.... it tells me the table exists/entry exists, etc.

[Chuck S]

Well you need to find out what is missing here.

In pp-inc.php you can set this line

$showsqldebug = 0;

to say this

$showsqldebug = 1;

Then maybe a more detailed error would be shown here

[Chuck S]

Using phpmyadmin try running this it looks to me as if your cache table is corrupt if it exists

REPAIR TABLE pics_cache

[DefenceTalk.com]

Originally Posted by Chuck S

Using phpmyadmin try running this it looks to me as if your cache table is corrupt if it exists

REPAIR TABLE pics_cache

This did it. Thank you!!!

Btw, I did not get any special error message with the debug mode on.