Beta 2 SQL Errors When Deleting & Missing Phrases

[dilbert05]

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"
4440

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

When a new link is added, the email notice is missing details:

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/ (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.
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/addlink.php?do=editlink&l=72
IP Address : xxx.xxx.x.x
Username : xxxxx
Classname : xx_xxxxxxxx
MySQL Version : 5.0.54-log

[BWJ]

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

[Brian]

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

[BWJ]

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:

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

[simsnet]

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

[BWJ]

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

[dilbert05]

Seems fixed, thanks.

[BWJ]

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! :)