bitweaver
Wiki
wiki Home
List Pages
wiki Books
Orphan Pages
wiki Rankings
Photos
List Galleries
Forums
Browse forums
Files
List Galleries
Categories
List Categories
Sign In
Message Boards
»
10. Development - Bugs
Newest
Oldest
Threaded
5
10
20
50
100
All
Messages
SQL error while viewing user list
Post Reply
grmi64
Joined: 14 Jan 2007
SQL error while viewing user list
Posted:19 Jan 2007 (01:45 UTC)
Post Reply
Page 1 of 1
1
Post
Title
Login
If you are already registered, please enter your login credentials.
Your Name
Anonymous Post
Content Format
Tiki Wiki Syntax
Allow HTML
{quote format_guid="bbcode" comment_id="8186" user="grmi64"}Here's the error I'm getting - any idea how to fix this? I haven't changed anything with the code. URL: http://www.ncffb.org/bitweaver/stats/users.php #### SQL: SELECT DATE_FORMAT(CAST( ``registration_date`` AS DATETIME ),'%Y-%m') AS period, COUNT(`user_id`) FROM `weaverusers_users` GROUP BY( DATE_FORMAT(CAST( ``registration_date`` AS DATETIME ),'%Y-%m') ) ORDER BY COUNT(`user_id`) DESC #### ADODB: Errno: 1064 Message: 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 'registration_date`` AS DATETIME ),'%Y-%m') AS period, COUNT(`use{/quote}
Recent Page Changes
welcome to bitweaver.org
Bitweaver Overview
ReleaseTwo Schema Changelog 2006
PressReleaseOne
Spider's Web
Press Release Two
BitcommercePackage
InfiniBand vs Ethernet Performance
InfiniBand for Dummies
Show More…