Results 1 to 8 of 8

Thread: Beta 2 SQL Errors When Deleting & Missing Phrases

  1. #1

    Default Beta 2 SQL Errors When Deleting & Missing Phrases

    Hi Brian,

    When I view the Moderation tab the table on the left appears to have a few misformed rows at the bottom.
    Also, it looks like a phrase might be missing in the table header above "No Links Awaiting Moderation"
    Attachment 4440

    There is a missing phrase in the Admin Options in the Links Options drop down.
    Attachment 4441

    When a new link is added, the email notice is missing details:
    Code:
    Hello,
    
    Cliff has just submitted a new link in the Blood Donor Centers category. You may view the link here:
    
    http://www.bloodbanktalk.com/links/
    
    Here are the details for that link:
    ************************
    Name: 
    URL: 
    Description: 
    User: Cliff
    ************************
    I deleted a link and get a database error. The link listed below isn't the one I was trying to delete. Then when I go back to the index page, it's still listed as the most recent link, but when I view the category, it's not there. I ran the maintenance scripts and that seemed to help.
    Code:
    Database error in vBulletin 3.7.0:
    Invalid SQL:
       UPDATE vB36_adv_links_categories SET
        linkcount = linkcount - 1,
     
        ,
        lastlinkid = '42',
        lastlinktitle = 'HCLL Users Group',
        lastlinkuserid = '321',
        lastlinkusername = 'CLIMBER514',
        lastlinkdateline = '1162319028'
     
       WHERE catid = 2;
    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 '
        lastlinkid = '42',
        lastlinktitle = 'HCLL Users Group',
        lastlinku' at line 4
    Error Number  : 1064
    Request Date  : Friday, May 30th 2008 @ 12:46:32 PM
    Error Date    : Friday, May 30th 2008 @ 12:46:34 PM
    Script        : http://www.bloodbanktalk.com/links/moderate.php
    Referrer      : http://www.bloodbanktalk.com/links/a...=editlink&l=72
    IP Address    : xxx.xxx.x.x
    Username      : xxxxx
    Classname     : xx_xxxxxxxx
    MySQL Version : 5.0.54-log
    Last edited by dilbert05; 05-30-2008 at 03:16 PM.

  2. #2
    Join Date
    Jul 2005
    Posts
    120

    Default Re: Beta 2 errors

    I think I have the same problem - besides that I am only able to see the 'delete link' phrase (image 1)

  3. #3
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Beta 2 SQL Errors When Deleting & Missing Phrases

    Thank you for pointing these things out. I've applied the fix to the download package here, so if you will download the files again, replace your links/moderate.php and forum/admincp/vbalinks_install.php files with the updated versions, then run this query via phpMyAdmin or your Admin CP:
    Code:
    UPDATE phrasetype SET fieldname = 'adv_links_moderate' WHERE fieldname = 'adv_links_moderation';
    After running the query, go to the admincp/vbalinks_install.php file in your browser, select the option there to re-install your phrases, and that should take care of these issues.

  4. #4
    Join Date
    Jul 2005
    Posts
    120

    Default Re: Beta 2 SQL Errors When Deleting & Missing Phrases

    Sorry didn't solve the problem for me

    Firstly I tried to reupload the files you mentioned. Then the whole package. Both times the SQl gave the same result:

    PHP Code:
    #1146 - Table 'login_servername_forums.phrasetype' doesn't exist 
    I tried both with PHPadmin and in the admin panel. After that I tried to reinstall phrases without luck - then, just to try - settings and templates.

  5. #5
    Join Date
    Nov 2006
    Location
    Italy
    Posts
    37

    Default Re: Beta 2 SQL Errors When Deleting & Missing Phrases

    Quote Originally Posted by Brian View Post
    Thank you for pointing these things out. I've applied the fix to the download package here, so if you will download the files again, replace your links/moderate.php and forum/admincp/vbalinks_install.php files with the updated versions, then run this query via phpMyAdmin or your Admin CP:
    Code:
    UPDATE phrasetype SET fieldname = 'adv_links_moderate' WHERE fieldname = 'adv_links_moderation';
    After running the query, go to the admincp/vbalinks_install.php file in your browser, select the option there to re-install your phrases, and that should take care of these issues.

    I had the same problems and this fix has resolved the issue for me.

    Thanks Brian.

  6. #6
    Join Date
    Jul 2005
    Posts
    120

    Default Re: Beta 2 SQL Errors When Deleting & Missing Phrases

    I have submitted a ticket with login details. I guess it is some little mistake as everything else seems to work.

  7. #7

    Default Re: Beta 2 SQL Errors When Deleting & Missing Phrases

    Seems fixed, thanks.

  8. #8
    Join Date
    Jul 2005
    Posts
    120

    Default Re: Beta 2 SQL Errors When Deleting & Missing Phrases

    Brian just solved my issue - and now it works! For everybody else. I use a prefix and then the sql should be:

    UPDATE table_prefixphrasetype SET fieldname = 'adv_links_moderate' WHERE fieldname = 'adv_links_moderation'

    Thank you to Brian for his super fast and efficient support!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hep! Missing phrases
    By etaslim in forum Troubleshooting & Problems
    Replies: 7
    Last Post: 07-20-2007, 12:38 PM
  2. Errors and Missing Images
    By bushka in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 02-19-2006, 08:34 AM
  3. Deleting 3.5.x???
    By Wedge in forum "How Do I..." Questions
    Replies: 6
    Last Post: 02-02-2006, 02:37 AM
  4. Phrases / Text missing
    By sapper6fd in forum Troubleshooting & Problems
    Replies: 3
    Last Post: 01-15-2006, 11:52 PM
  5. Missing phrases
    By orca in forum Bugs From 1.0 RC1
    Replies: 9
    Last Post: 12-24-2005, 03:41 AM

Posting Permissions

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