vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   mysql error can anyone help? (https://vborg.vbsupport.ru/showthread.php?t=115732)

VBUsers 05-16-2006 04:08 AM

mysql error can anyone help?
 
i get this error. its from the vb favorites hack i beleive.

Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE FROM smora_favorites as favorites
WHERE userid = 6784
OR (entry_type = 'user' AND entry_id = 6784);

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 favorites
WHERE userid = 6784
OR (entry_type = 'user' AN
Error Number : 1064
Date : Monday, May 15th 2006 @ 07:58:46 AM
Script : http://www.thenextelforums.com
Referrer : http://www.thenextelforums.com
IP Address : 0000000000
Username : Caddyman
Classname : vb_database

hambil 05-16-2006 10:53 AM

Quote:

Originally Posted by lowandloudinc
i get this error. its from the vb favorites hack i beleive.

Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE FROM smora_favorites as favorites
WHERE userid = 6784
OR (entry_type = 'user' AND entry_id = 6784);

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 favorites
WHERE userid = 6784
OR (entry_type = 'user' AN
Error Number : 1064
Date : Monday, May 15th 2006 @ 07:58:46 AM
Script : http://www.thenextelforums.com
Referrer : http://www.thenextelforums.com
IP Address : 0000000000
Username : Caddyman
Classname : vb_database

The 'as favorites' isn't necessary and typically not used in a delete. Your version of MySQL may not even support it. Remove the 'as favorites' and you should be okay.

You also might want to post this in the favorites hack thread.

VBUsers 05-25-2006 06:30 AM

Quote:

Originally Posted by hambil
The 'as favorites' isn't necessary and typically not used in a delete. Your version of MySQL may not even support it. Remove the 'as favorites' and you should be okay.

You also might want to post this in the favorites hack thread.


do you mean remove the table or just the words?

hambil 05-25-2006 09:52 AM

just the words "as favorites"


All times are GMT. The time now is 12:15 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02111 seconds
  • Memory Usage 1,717KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete