SQl Problem

[FightRice]

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE adv_pages SET type = 'template' WHERE template != ''
mysql error: Table 'fightricevb.adv_pages' doesn't exist

mysql error number: 1146

Date: Friday 03rd of June 2005 11:54:13 AM
Script: http://www.xxxxxx543xx.com/admincp/vbacmps_install.php
Referer: http://www.5245xxx.com/admincp/vbacmps_install.php
Username: Dave
IP Address: xxxxxxxx


I have a table prefix of vb_3 but it doesn't seem to be picking it up :cry:

[FightRice]

Having all kinds of problems :cry:

[FightRice]

ok, i fixed mine, by hardcoding the vb_3 prefix in :woot: Now time to set everything up again :(

[FightRice]

obvisously that wasn't a smart idea either, All kinds of other problems now


:cry: I hate being the first to update :D

[Brian]

It looks like I missed a table prefix in the install file, and that's what's causing the problem. If you'll download the files from here again, then look in the install file for this bit of code (around line 2224):

// Alter module table


Either comment out or remove the bit of code between that and this bit of code:
$DB_site->query("UPDATE " . TABLE_PREFIX . "adv_pages SET active = 1");

Then run the upgrade again and you should be all set. Or, if you're not comfortable with making changes like that and such and would rather submit a support ticket I'll be glad to get things straightned out.

[FightRice]

What if my install file is only around 2057 lines long and not 2224? :-p

and it appears the phrases aren't working now, i tried the usual fix or goin in and saving one, but that didn't seem to work this time

[ConqSoft]

You sure you uploaded the new install file?

[FightRice]

yea, i even just redownloaded it from the members area :(

[Brian]

What if my install file is only around 2057 lines long and not 2224? :-p

and it appears the phrases aren't working now, i tried the usual fix or goin in and saving one, but that didn't seem to work this time
Then that means I'm an idiot and accidentally uploaded the files from 1.0.0 instead of 2.0. :o
Just updated the package again, with the correct files this time.

[FightRice]

oopsy

[FightRice]

Alright, Got that all taken car of, forums back up and running, Just got some other stuff i'll have to fixor later BUT i get this when tring to add news

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT threadid, firstpostid FROM vb_3thread
LEFT JOIN vb_3deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE visible = 1 AND open != 10 AND thread.forumid IN(38) AND deletionlog.primaryid IS NULL
ORDER BY dateline DESC
LIMIT 8

mysql error: Unknown table 'thread' in where clause

mysql error number: 1109

Date: Friday 03rd of June 2005 01:08:53 PM
Script: http://www.fightrice.com/
Referer:

[FightRice]

Oh and btw, Thanks :woot:

[Brian]

This is what happens when Zachery slacks on his beta testing duities since he's the one who uses table prefixes and always finds my mistakes. :p
I just updated the files here to make things easy for you, so if you'll download the package from here again and replace the modules/news.php file with the new one in the package that should take care of the problem.

[FightRice]

Awesome, does this make me an offical problem finder?

[Brian]

Yup. Looks like we might just have to fire Zach and hire you in his place. :p

[FightRice]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb_3thread AS thread
LEFT JOIN vb_3forum USING (forumid)
LEFT JOIN vb_3post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_3icon USING (iconid)
LEFT JOIN vb_3user AS user ON (user.userid = post.userid)

LEFT JOIN vb_3usertextfield AS usertextfield ON (post.userid = usertextfield.userid)

LEFT JOIN vb_3avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb_3customavatar as customavatar ON (customavatar.userid = user.userid)

LEFT JOIN vb_3subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '7')
LEFT JOIN vb_3deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(3087,3013,2994)

GROUP BY post.postid
ORDER BY sticky DESC, postdateline DESC
LIMIT 8

mysql error: Unknown table 'forum' in field list

mysql error number: 1109

Date: Friday 03rd of June 2005 01:23:34 PM
Script: http://www.xxxxxxxxxxxxxxxxxxxxxxx.com/
Referer:
Username: Dave
IP Address: xxxx


maybe its on my side?

[Brian]

Nope, that's another table prefix issue. I just updated the news.php file here again, so hopefully that will be the last one.

[FightRice]

:-d

[FightRice]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb_3thread AS thread
LEFT JOIN vb_3forum USING AS post (forumid)
LEFT JOIN vb_3post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_3icon USING (iconid)
LEFT JOIN vb_3user AS user ON (user.userid = post.userid)

LEFT JOIN vb_3usertextfield AS usertextfield ON (post.userid = usertextfield.userid)

LEFT JOIN vb_3avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb_3customavatar as customavatar ON (customavatar.userid = user.userid)

LEFT JOIN vb_3subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '7')
LEFT JOIN vb_3deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(3087,3013,2994)

GROUP BY post.postid
ORDER BY sticky DESC, postdateline DESC
LIMIT 8

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS post (forumid)
LEFT JOIN vb_3post AS post ON (post.postid = thread.firstp' at line 8

mysql error number: 1064

Date: Friday 03rd of June 2005 01:40:25 PM
Script: http://www.fightrice.com/
Referer:
Username: Dave
IP Address: xxx

[FightRice]

One more time, :-D It all looks the same till the bottom i think

[Brian]

It's getting more and more obvious that it's been a long day, isn't it? I've just updated the file again, hopefully for the last time this time. :)

[FightRice]

Yea, i here yeah :lol: Atleast i'm a calm customer and not some irrate person :-p

[Brian]

Very true. It's frustrating enough to know that those mistakes were there in the first place, and would be even worse with someone getting irrate.