Database error, need help please . . .

[Teresa]

Hi Folks,

I had to move my web file from one computer to a new computer. This was the first time I had to do that and I ended up causing all kinds of problems for myself. I ended up deleting my Forum directory (not backed up of course). I had the hosting company restore it.

However, when I go to view a thread or hit post to finish posting a new thread I get the generic database error. It actually does manage to post a new thread, but then I can't get into it.

Here is the source code from the error:


<!-- Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM
post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>989178695)
WHERE
post.postid IN (0,15)
ORDER BY dateline

mysql error: Unknown column 'customavatar.dateline' in 'field list'
mysql error number: 1054
Date: Sunday 06th of May 2001 02:06:35 PM
Script: /forum/showthread.php?s=&threadid=10
Referer: http://cavyrescue.com/forum/forumdis...?s=&forumid=26
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

-----------------

I'm hoping this is a simple fix. I'm very much a neophyte on this and don't have permissions to run jobs at my hosted site. I would have to call them and have them do it.

I upgraded from Candidate 1 to Candidate 2 against the hope that something in the upgrade script would magically fix it, but no go. Still have the error, but I did do a successful upgrade.

Thanks,

[Mike Sullivan]

Have you completely run upgrade4.php in the past?

[Teresa]

There was one time when I wasn't sure about the sequence of what happened. It was a while ago. As I recall it seemed like the upgrade script did two together. It was around that time. But, everything seemed to be working. So I thought I had been upgrading successfully.

So, I guess it's possible I may have goofed somewhere.

[Mike Sullivan]

You'll want to run the following MySQL query on your databiase via telnet or phpMyAdmin:

ALTER TABLE customavatar ADD dateline int(10) unsigned DEFAULT '0' NOT NULL;

[Teresa]

Halfway home!!

Now I can view all the threads that are there, but when I try to post a new thread I get this:


<!-- Database error in vBulletin: Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (7,16,1),(2,16,1),(6,16,0)
mysql error: Unknown column 'intitle' in 'field list'
mysql error number: 1054
Date: Sunday 06th of May 2001 03:55:26 PM
Script: /forum/newthread.php
Referer: http://www.cavyrescue.com/forum/newt...ead&forumid=14
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

Related problem???

[Mike Sullivan]

Well, first -- would you change your technical email address setting in your config.php?

Ok, now I'm 95% sure you didn't run upgrade4.php fully, but alas, since you have parts of it now, you won't really be able to run it easily...

Do you have an option "Allow Ignore Moderators" in your "user and registration" section of your control panel options?

[Teresa]

Well, first -- would you change your technical email address setting in your config.php?

Oh.... That is where the email for database problems go to you instead of me? (sheepish, sorry about that) I'm not sure how I change it.

Ok, now I'm 95% sure you didn't run upgrade4.php fully, but alas, since you have parts of it now, you won't really be able to run it easily...

Bummer.

Do you have an option "Allow Ignore Moderators" in your "user and registration" section of your control panel options?

No.

[Teresa]

Never mind about how to update config.php. Dumb question. I'll take care of it.

[Mike Sullivan]

You were sending your error messages to John Although I don't think he checks that account (or forwards it to /dev/null).

Ok, you didn't run upgrade4.php. Drop the field I told you to add and run it:

ALTER TABLE customavatar DROP dateline;

[Teresa]

What exactly do you mean by "drop the field I told you to add?" If you could give me the command to do that, it would save me countless learning curve hours!! Or, do I just run the command you listed (alter table)?

Don't forget I'm a neophyte!

Do I run upgrage4?

oh yeah, I did hear from John!

[Mike Sullivan]

Run this command to drop the field:
ALTER TABLE customavatar DROP dateline;

[Teresa]

Not sure if I successfully deleted it or not, but it's gone and I still have a problem.

<!-- Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM
post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>989353136)
WHERE
post.postid IN (0,9,10,11)
ORDER BY dateline

mysql error: Unknown column 'customavatar.dateline' in 'field list'
mysql error number: 1054
Date: Tuesday 08th of May 2001 02:33:57 PM
Script: /forum/showthread.php?s=&threadid=6
Referer: http://cavyrescue.com/forum/forumdis...p?s=&forumid=3
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>


Is there a next step?

[Mike Sullivan]

Well, I'm staring at upgrade4.php, and it adds that field, so I'm guessing you still didn't run upgrade4....

[Teresa]

Oh. Sorry. I wasn't sure specifically if I was supposed to do that or not. I'm erring on the side of caution so I don't make it worse.

I'll go run it now.

Thanks,

[Teresa]

Okay, it died somewhere in what looked like the middle of step 7.

Trying to back into the forum gives me this:

<!-- Database error in vBulletin: Invalid SQL:
SELECT
session.userid AS sessionuserid,
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM
post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
LEFT JOIN session ON (session.userid = user.userid
AND session.userid > 0

AND session.lastactivity>989353136)
WHERE
post.postid IN (0,9,10,11)
ORDER BY dateline

mysql error: Unknown column 'customavatar.dateline' in 'field list'
mysql error number: 1054
Date: Tuesday 08th of May 2001 02:33:57 PM
Script: /forum/showthread.php?s=&threadid=6
Referer: http://cavyrescue.com/forum/forumdis...p?s=&forumid=3
-->
</td></tr></table>
<p>There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p>

----

Is it really bad now?