newreply.php possible issue

[ricoche]

Hi there,

I just upgraded to the latest beta2 version and am getting the following database error when replying to a link. The installation seemed to go well and everything looks updated so I'm not sure where to look here. The newreply.php is the latest uploaded from the update.

http://www.ricoche.net/links/

Thanks! - Jim


Database error in vBulletin 3.7.0:

Invalid SQL:

UPDATE adv_links_categories SET
postcount = postcount + 1
WHERE catid IN();

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 ')' at line 3
Error Number : 1064
Request Date : Monday, June 2nd 2008 @ 09:18:08 PM
Error Date : Monday, June 2nd 2008 @ 09:18:08 PM
Script : http://www.ricoche.net/links/newreply.php
Referrer : http://www.ricoche.net/links/newreply.php?l=2
Classname : vB_Database
MySQL Version : 5.0.51a-community

[ricoche]

I should add that when I reply to a link it actually gets entered into the database, but doesn't seem to get pulled or something along those lines.

When I physically delete the reply, I get the following error.


Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/ricochen/public_html/links/moderate.php on line 2060

Warning: Cannot modify header information - headers already sent by (output started at [path]/includes/class_core.php:3237) in /home/ricochen/public_html/links/moderate.php on line 2072

[Brian]

Thanks for pointing this out. I've updated the download package here to include the fix, so if you will download the files from here again and replace your links/addlink.php file with the updated version, that should take care of the issue.

[ricoche]

Splendid! Thanks Brian.

Jim

[TriMe]

I redownloaded the package and I'm still getting an error that I was mentionning here (http://www.vbadvanced.com/forum/showthread.php?t=29966).

TriMe

[Brian]

Try deleting the links/moderate.php file from your server and then re-upload the one that you just downloaded. If that does not help, please submit a support ticket via the Members' Area here and I'll take a look at things for you.

[TriMe]

Yes I tried what you suggested, still get the error.

Ill submit a ticket now,

Thanks Brian