SQL Error
Replies
In Home Appliances http://subeta.net/shop.php?shopid=23
SQL 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 ''ô6JÉã˜ÅÏ–œ¾¶g'' LIMIT 1' at line 1
Array
(
[0] => Array
(
[file] => /www/subeta.net/include/class/database.new.php
[line] => 141
[function] => on_error
[class] => database
[object] => database Object
(
[link_master] => Resource id
[link_slave] => Resource id
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => Resource id #57
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM item WHERE itemid='ô6JÉã˜ÅÏ–œ¾¶g'' LIMIT 1
[1] => Resource id #41
)
)
[1] => Array
(
[file] => /www/subeta.net/include/class/database.new.php
[line] => 345
[function] => query
[class] => database
[object] => database Object
(
[link_master] => Resource id #41
[link_slave] => Resource id #41
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => Resource id #57
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM item WHERE itemid='ô6JÉã˜ÅÏ–œ¾¶g'' LIMIT 1
)
)
[2] => Array
(
[file] => /www/subeta.net/include/default.php
[line] => 1501
[function] => query_first
[class] => database
[object] => database Object
(
[link_master] => Resource id #41
[link_slave] => Resource id #41
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => Resource id #57
)
[type] => ->
[args] => Array
(
[0] => SELECT * FROM item WHERE itemid='ô6JÉã˜ÅÏ–œ¾¶g''
)
)
[3] => Array
(
[file] => /www/subeta.net/shop.php
[line] => 189
[function] => getItem
[args] => Array
(
[0] => ô6JÉã˜ÅÏ–œ¾¶g'
)
)
)
Do you remember if this happened when you first opened the page or after you tried to select an item?
When I selected the item. A dumpster if I remember right. I also went back through and it happened a second time. This was using the Shops drop down menu. The third and fourth time happened on refreshes. I finally solved it by opening a new window.
no prob. Hope that helps. Sorry I forgot to ping you. Had a ton of windows open....
I had this SQL error whilst trying to remove items from my gallery -
SQL error: Deadlock found when trying to get lock; try restarting transaction Array ( [0] => Array ( [file] => /www/subeta.net/include/class/database.new.php [line] => 141 [function] => on_error [class] => database [object] => database Object ( [link_master] => Resource id [link_slave] => Resource id [dblist] => Array ( )
[log_queries] => 1
[last_query] => 1
)
[type] => ->
[args] => Array
(
[0] => UPDATE ushop_stock SET price='0',catid='0' WHERE itemid='146494' AND shopid='258563'
[1] => Resource id #42
)
)
[1] => Array
(
[file] => /www/subeta.net/myshop.php
[line] => 905
[function] => query
[class] => database
[object] => database Object
(
[link_master] => Resource id #42
[link_slave] => Resource id #42
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => 1
)
[type] => ->
[args] => Array
(
[0] => UPDATE ushop_stock SET price='0',catid='0' WHERE itemid='146494' AND shopid='258563'
)
)
)
And here's another that was fixed when hitting back and reloading the page through link clicking. Riverside Training Center: http://subeta.net/explore/train.php
SQL 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 statiwant FROM pets WHERE petid=916304 LIMIT 1' at line 1
Array
(
[0] => Array
(
[file] => /www/subeta.net/include/class/database.new.php
[line] => 141
[function] => on_error
[class] => database
[object] => database Object
(
[link_master] => Resource id
[link_slave] => Resource id
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => Resource id #113
)
[type] => ->
[args] => Array
(
[0] => SELECT AS statiwant FROM pets WHERE petid=916304 LIMIT 1
[1] => Resource id #44
)
)
[1] => Array
(
[file] => /www/subeta.net/include/class/database.new.php
[line] => 366
[function] => query
[class] => database
[object] => database Object
(
[link_master] => Resource id #44
[link_slave] => Resource id #44
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => Resource id #113
)
[type] => ->
[args] => Array
(
[0] => SELECT AS statiwant FROM pets WHERE petid=916304 LIMIT 1
)
)
[2] => Array
(
[file] => /www/subeta.net/explore/train.php
[line] => 186
[function] => query_first_obj
[class] => database
[object] => database Object
(
[link_master] => Resource id #44
[link_slave] => Resource id #44
[dblist] => Array
(
)
[log_queries] => 1
[last_query] => Resource id #113
)
[type] => ->
[args] => Array
(
[0] => SELECT AS statiwant FROM pets WHERE petid=916304
)
)
)
this occurred AFTER selecting an item to buy in the Music shop, I did end up with the item in my inventory.
SQL 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 1
Array
(
[0] => Array
(
[file] => /www/subeta.net/include/class/database.new.php
[line] => 141
[function] => on_error
[class] => database
[object] => database Object
(
[link_master] => Resource id
[link_slave] => Resource id
[dblist] => Array
(
)
[log_queries] => 1 [last_query] => Resource id )
[type] => -> [args] => Array ( [0] => INSERT INTO user_items (id,userid,itemid) VALUES ('',617255,) [1] => Resource id )
)
[1] => Array ( [file] => /www/subeta.net/include/class/database.new.php [line] => 335 [function] => query [class] => database [object] => database Object ( [link_master] => Resource id [link_slave] => Resource id [dblist] => Array ( )
[log_queries] => 1 [last_query] => Resource id )
[type] => -> [args] => Array ( [0] => INSERT INTO user_items (id,userid,itemid) VALUES ('',617255,) )
)
[2] => Array ( [file] => /www/subeta.net/include/user.php [line] => 433 [function] => exec [class] => database [object] => database Object ( [link_master] => Resource id [link_slave] => Resource id [dblist] => Array ( )
[log_queries] => 1 [last_query] => Resource id )
[type] => -> [args] => Array ( [0] => INSERT INTO user_items (id,userid,itemid) VALUES ('',617255,) )
)
[3] => Array ( [file] => /www/subeta.net/include/random.php(31) : eval()'d code [line] => 4 [function] => give_item [args] => Array ( [0] => )
)
[4] => Array ( [file] => /www/subeta.net/include/random.php [line] => 31 [function] => eval )
[5] => Array ( [file] => /www/subeta.net/include/header.php [line] => 604 [args] => Array ( [0] => /www/subeta.net/include/random.php )
[function] => require_once )
[6] => Array ( [file] => /www/subeta.net/include/global.php [line] => 544 [args] => Array ( [0] => /www/subeta.net/include/header.php )
[function] => require_once )
[7] => Array ( [file] => /www/subeta.net/shop.php [line] => 192 [function] => doHeader [args] => Array ( [0] => Purchasing: Music Theory Grade 3
