vb.org Archive - Display Order: Database Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vbArticles (https://vborg.vbsupport.ru/forumdisplay.php?f=106)

- - Display Order: Database Error (https://vborg.vbsupport.ru/showthread.php?t=76673)

LOTR	02-20-2005 07:08 AM

Display Order: Database Error

I have add categories on the aticlesm however when i try to display the order of categories and error occured.

PHP Code:


		
			
Invalid SQL: 

                    UPDATE articles_category

                    SET categoryorder=

                    WHERE articles_categoryid=16

                

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 'WHERE articles_categoryid=16' at line 3



mysql error number: 1064



Date: Sunday 20th of February 2005 05:06:02 PM

Script: http://mydomain.com/forum/admincp/vbarticles.php

Referer: http://mydomain.com/forum/admincp/vbarticles.php?do=modifycat

Username: Admin

IP Address: xxx.xxx.xx.xxx

Any ideas to fix it cing? :)
Thanks

LOTR	02-22-2005 09:11 AM

Cing,

These error still occured when ever i tried to save display order on category articles.

PHP Code:


		
			
Database error in vBulletin 3.0.7:



Invalid SQL: 

                    UPDATE articles_category

                    SET categoryorder=

                    WHERE articles_categoryid=16

                

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 'WHERE articles_categoryid=16' at line 3



mysql error number: 1064



Date: Tuesday 22nd of February 2005 07:08:43 PM

Script: http://mysite.com/forum/admincp/vbarticles.php

Referer: http://mysite.com/forum/admincp/vbarticles.php?do=modifycat

Please take a look at it.

cinq	03-15-2005 12:19 PM

Sorry to dig this up, am going through all the threads in this subforum to make sure I don't miss anything out.

I cannot replicate this, can you ?

jlaine

03-27-2005 01:00 AM

Quote:

Originally Posted by cinq

Sorry to dig this up, am going through all the threads in this subforum to make sure I don't miss anything out.

I cannot replicate this, can you ?

I can cinq - every time I try to update a category order in the system it repeats that error.

jlaine

04-05-2005 03:39 AM

Just for further review -

I found if you delete the category from the admin panel, it doesn't apparently remove the reference to it from articles_category table - that seems to be causing articles_categoryid to reference the wrong catid when you go to update.

Mine was showing

Invalid SQL:
UPDATE articles_category
SET categoryorder=
WHERE articles_categoryid=5

But the actual category I was trying to update was 8..

Upon removing the categories that were deleted prior via sqladmin and attempting to update the categories again, script worked fine.

All times are GMT. The time now is 07:32 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01119 seconds Memory Usage 1,732KB 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)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
Messages: