XSCCS

The Stig	#1 2010-11-18 05:19
Members	Can anyone please help with this error when i install xsccs plugin... Fatal error : 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 'ORDER BY chall_when ASC LIMIT 5' at line 1 This looks like the offending line below but i can't see whats wrong... $sql_xsccs_g_challenges = sed_sql_query("SELECT * FROM $db_xsccs_challenge ORDER BY chall_when ASC LIMIT ".$display_items); Oh...and the database is installed.
This post was edited by The Stig (2010-11-18 05:52, 13 years ago)

The Stig

#1 2010-11-18 05:19

Can anyone please help with this error when i install xsccs plugin...

Fatal error : 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 'ORDER BY chall_when ASC LIMIT 5' at line 1

This looks like the offending line below but i can't see whats wrong...

$sql_xsccs_g_challenges = sed_sql_query("SELECT * FROM $db_xsccs_challenge ORDER BY chall_when ASC LIMIT ".$display_items);

Oh...and the database is installed.

This post was edited by The Stig (2010-11-18 05:52, 13 years ago)

tensh	#2 2010-11-18 17:59
Contributors Thanked: 12 times	Provide me a link to the plugin, I'll try to check it out. First that comes to my mind: try to check if $db_xsccs_challenge points to correct database table (echo $db_xsccs_challenge;), and then check it the fields name are correct. You can also try to surround $db_xsccs_challenge like this: ".$db_xsccs_challenge." just in case.

The Stig	#3 2010-11-18 22:14
Members	Thanks for the reply tensh...but since this post i have done 4 fresh installs of cotonti 0.6.11 and attempted to install xsccs on each occasion with the same error. I have checked rechecked that the db is ok with all the tables correctly installed including challenge, I have also put the tb2 files in the correct place as doing so eliminates another 2 errors...i'm at a loss tbh as the syntax to the sql statement looks fine to me. In between all of this i'm still working on the old site which is still running on seditio 130...once i have sorted everything i hope to help out more with cotonti. Stig Added 5 hours 20 minutes later: Oh and btw...when i install it and get that error...thats it nada nothing, can't access anything, i have to dump all the tables and do a fresh install of cotonti. so i can't give u a link when its install...it just leads to a blank page with that sql error on it whichever page i go to. Added 32 minutes later: Its a pitty about this plugin it was an excellent piece of work and exactly what a clan needs Maybe some php whizzkid will adapt it for cotonti...well heres hoping.
This post was edited by The Stig (2010-11-19 04:11, 13 years ago)

The Stig

#3 2010-11-18 22:14

Members

Thanks for the reply tensh...but since this post i have done 4 fresh installs of cotonti 0.6.11 and attempted to install xsccs on each occasion with the same error. I have checked rechecked that the db is ok with all the tables correctly installed including challenge, I have also put the tb2 files in the correct place as doing so eliminates another 2 errors...i'm at a loss tbh as the syntax to the sql statement looks fine to me.

In between all of this i'm still working on the old site which is still running on seditio 130...once i have sorted everything i hope to help out more with cotonti.

Stig

Added 5 hours 20 minutes later:

Oh and btw...when i install it and get that error...thats it nada nothing, can't access anything, i have to dump all the tables and do a fresh install of cotonti. so i can't give u a link when its install...it just leads to a blank page with that sql error on it whichever page i go to.

Added 32 minutes later:

Its a pitty about this plugin it was an excellent piece of work and exactly what a clan needs

Maybe some php whizzkid will adapt it for cotonti...well heres hoping.

This post was edited by The Stig (2010-11-19 04:11, 13 years ago)

tensh	#4 2010-11-19 18:16
Contributors Thanked: 12 times	So... give me the link to the plugin zip, to the files. I can try to adapt it.

pieter	#5 2010-11-19 19:30
Team Thanked: 9 times	I think it is solved: http://www.cotonti.com/forums.php?m=posts&q=6033&n=last#bottom ... can we help you ...