Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived General Discussion Weird in 1.72
Weird in 1.72
  • El Forum
    Guest
  •  
#5
11-20-2009, 03:53 PM

[eluser]kodai[/eluser]
Quote:A Database Error Occurred

Error Number: 1064

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 ' `ID_MENU)`, `ID_MENU_PARENT` ASC, `MENU_PATH` ASC' at line 3

SELECT `ID_MENU`, concat(repeat(" ", length(MENU_PATH)/4), `MENU_NAME` ) as MENU_NAME2, `tbl_menu`.* FROM (`tbl_menu`) ORDER BY concat(MENU_PATH, if(ID_MENU>999, `''`, if(ID_MENU>99, `'0'`, if(ID_MENU>9, `'00'`, `'000')))`, `ID_MENU)`, `ID_MENU_PARENT` ASC, `MENU_PATH` ASC

This the last error Sad, i have try also to change 0 with repeat(char(48),x) but still error.


Messages In This Thread
Weird in 1.72 - by El Forum - 11-19-2009, 04:18 AM
Weird in 1.72 - by El Forum - 11-19-2009, 04:37 AM
Weird in 1.72 - by El Forum - 11-19-2009, 05:23 AM
Weird in 1.72 - by El Forum - 11-19-2009, 05:28 AM
Weird in 1.72 - by El Forum - 11-20-2009, 03:53 PM
Weird in 1.72 - by El Forum - 11-20-2009, 04:32 PM
Weird in 1.72 - by El Forum - 11-20-2009, 06:11 PM
Weird in 1.72 - by El Forum - 11-23-2009, 06:26 PM
Weird in 1.72 - by El Forum - 12-07-2009, 09:27 AM
Weird in 1.72 - by El Forum - 12-08-2009, 04:31 PM



Theme © iAndrew 2016 - Forum software by © MyBB