Installing VB 4 with SQL Errors in 3.8.5. Can I install it anyways?

[Fungsten]

I've been having a lot of DB errors on VB 3.5.8. Also when attempting to reinstall VB 3.5 I get an "unable to find site" after clicking on "Upgrade" - step 3. I thought that one solution might be to install VB 4.0. Are these errors going to interfere with an upgrade?

In the ACP Index:

Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Tuesday, March 30th 2010 @ 03:42:38 PM
Error Date : Tuesday, March 30th 2010 @ 03:42:38 PM
Script : http://www.XXXXXXXXXXXXforum/admincp/index.php?do=home
Referrer : http://www.XXXXXXXXXX.com/forum/admi...dex.php?do=nav
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.89-community

This happens when clicking on a username:

Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height

FROM album AS album
LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)

WHERE album.userid = 17
AND album.state IN ('public', 'private', 'profile')


ORDER BY album.lastpicturedate DESC
LIMIT 2;
MySQL Error : Table 'XXXXXXXXXXXX.picture' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 30th 2010 @ 03:52:20 PM
Error Date : Tuesday, March 30th 2010 @ 03:52:21 PM
Script : http://www.XXXXXXXX.com/forum/member.php?u=17
Referrer : http://www.XXXXXXXXXXXXXX.com/forum/...e&pp=50&page=1
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.89-community

This happens when clicking on one particular post:

Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,9129,9131,9137,9148,9149,9150,9151,9174,9354,936 3,9401,9404,9485,9490,9495)
ORDER BY attachmentid;
MySQL Error : Unknown column 'extension' in 'from clause'
Error Number : 1054
Request Date : Tuesday, March 30th 2010 @ 03:55:47 PM
Error Date : Tuesday, March 30th 2010 @ 03:55:47 PM
Script : http://www.XXXXXXXXXX.com/forum/showthread.php?t=798
Referrer : http://www.XXXXXXXXXXXX.com/forum/forumdisplay.php?f=53
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.89-community

There are most likely more but they would be taking up board space. TIA.

[borbole]

What were the most recent modifications you did to your forum prior to the issues popping up?

From the errors you posted it seems like you are missing a db table and and in the other error, that column doesn't exist in the table or maybe it is misspelled.

[Fungsten]

Originally Posted by borbole

What were the most recent modifications you did to your forum prior to the issues popping up?

From the errors you posted it seems like you are missing a db table and and in the other error, that column doesn't exist in the table or maybe it is misspelled.

Actually what started it was I was updating another site and put in the PW an Username for another site. So I went back and corrected it - on the updated site - but then these errors started to occur from which I got the wrong PW and username. I tried to run some SQL commands but they didn't do any good.

[borbole]

Originally Posted by Fungsten

Actually what started it was I was updating another site and put in the PW an Username for another site. So I went back and corrected it - on the updated site - but then these errors started to occur from which I got the wrong PW and username. I tried to run some SQL commands but they didn't do any good.

I can''t fully follow you, sorry. Can you please be a bit more detailed? It will help us in figuring out what might have caused the issue.

One word of advice if I may, don''t just run queries at the db, if you don''t know what you are doing, that is. It will make matters worse.

[Fungsten]

Originally Posted by borbole

I can''t fully follow you, sorry. Can you please be a bit more detailed? It will help us in figuring out what might have caused the issue.

When updating I had inadvertantly used the username and pw from another site own to update another site I own. When I found the error in the password/username switch I put in the correct password/username into the config file everything worked in the updated site but the other site got messed up.

Just thinking, could have the VB 3.8.5 tables been messed up due to any "cross data" corruption

One word of advice if I may, don''t just run queries at the db, if you don''t know what you are doing, that is. It will make matters worse.

I was told the commands by Lynne.

[borbole]

Originally Posted by Fungsten

When updating I had inadvertantly used the username and pw from another site own to update another site I own. When I found the error in the password/username switch I put in the correct password/username into the config file everything worked in the updated site but the other site got messed up.

Just thinking, could have the VB 3.8.5 tables been messed up due to any "cross data" corruption




I was told the commands by Lynne.

Are you sure that only the db user/password was switched and not the db as well? Also did you double check that the switch back was done properly?

Try this. Create a new db user and password at the mysql area in the cp of your host, then assign this new user/password to the db where your forum with issues resides on and grant it full permission/access. Then update the config.php file with the new username/pasword. And see how it will go.

Also can you check if this table exists at your db? I mean the ones that is reporting as missing by Mysql error.

MySQL Error : Table 'XXXXXXXXXXXX.picture' doesn't exist

Ah ok then, regarding the queries. If Lynne told you what to run then you can''t go wrong on her advice. She knows her staff pretty well. But I thought that you were running the queries on your own, hence my advice above.

[Fungsten]

Originally Posted by borbole

Are you sure that only the db user/password was switched and not the db as well? Also did you double check that the switch back was done properly?

Try this. Create a new db user and password at the mysql area in the cp of your host, then assign this new user/password to the db where your forum with issues resides on and grant it full permission/access. Then update the config.php file with the new username/pasword. And see how it will go.

Also can you check if this table exists at your db? I mean the ones that is reporting as missing by Mysql error.

MySQL Error : Table 'XXXXXXXXXXXX.picture' doesn't exist

Ah ok then, regarding the queries. If Lynne told you what to run then you can''t go wrong on her advice. She knows her staff pretty well. But I thought that you were running the queries on your own, hence my advice above.

Didn't work.

Thanks! But can we get back to if whether or not I can install VB 4?

[borbole]

Originally Posted by Fungsten

Didn't work.

Thanks! But can we get back to if whether or not I can install VB 4?

Do you mean install or upgrade? If you meant upgrading your forum I don''t think it will work on the current database with all those errors. Hence my suggestions to try and fix the errors first.

But if you want, make a backup of the db in the current state and restore it at your test forum and try to do an upgrade there and hope for a miracle.

How about the table that is reporting as missing in the mysql error, did you check it at the db if it is there or it is really missing? Also make a full inventry for all the other tables.

Or another easy way would be to restore your most recent backup and then upgrade to vb 4. But all the topics, posts, members etc made from the time of that backup and onwards will be lost.

[Fungsten]

Originally Posted by borbole

Do you mean install or upgrade? If you meant upgrading your forum I don''t think it will work on the current database with all those errors. Hence my suggestions to try and fix the errors first.

But if you want, make a backup of the db in the current state and restore it at your test forum and try to do an upgrade there and hope for a miracle.

How about the table that is reporting as missing in the mysql error, did you check it at the db if it is there or it is really missing? Also make a full inventry for all the other tables.

Or another easy way would be to restore your most recent backup and then upgrade to vb 4. But all the topics, posts, members etc made from the time of that backup and onwards will be lost.

Did you want to give it a try. How much would you charge? PM me.

[borbole]

Originally Posted by Fungsten

Did you want to give it a try. How much would you charge? PM me.

If you are offering money to have this fixed, then I think it would be best posted here:

https://vborg.vbsupport.ru/forumdisplay.php?f=30

P.s. you didn''t answer my question about the table that is reporting as missing in the mysql error, did you check it at the db if it is there or it is really missing?

P.p.s. Do you have a recent backup from before those errors popped up?