Page 1 of 2 12 LastLast
Results 1 to 20 of 23

Thread: SQl Problem

  1. #1
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default SQl Problem

    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:

  2. #2
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    Having all kinds of problems :cry:

  3. #3
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

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

  4. #4
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

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


    :cry: I hate being the first to update

  5. #5
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQl Problem

    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:
    PHP 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.

  6. #6
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    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
    Last edited by FightRice; 06-03-2005 at 03:57 PM.

  7. #7
    Senior Member ConqSoft's Avatar
    Join Date
    Jan 2004
    Location
    Raleigh, NC
    Posts
    1,614

    Default Re: SQl Problem

    You sure you uploaded the new install file?
    My Blog
    GPS Discussion Forum

    *** Please do not contact me privately for help. Thanks. ***

  8. #8
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    yea, i even just redownloaded it from the members area

  9. #9
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQl Problem

    Quote Originally Posted by 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
    Then that means I'm an idiot and accidentally uploaded the files from 1.0.0 instead of 2.0.
    Just updated the package again, with the correct files this time.

  10. #10
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    oopsy

  11. #11
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    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:

  12. #12
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    Oh and btw, Thanks :woot:

  13. #13
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQl Problem

    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.
    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.

  14. #14
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    Awesome, does this make me an offical problem finder?

  15. #15
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQl Problem

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

  16. #16
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    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?

  17. #17
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: SQl Problem

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

  18. #18
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    :-d

  19. #19
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

    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

  20. #20
    Senior Member
    Join Date
    Feb 2005
    Posts
    151

    Default Re: SQl Problem

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

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •