Hello,
I am very new to this game and currently setup this test install as part of my getting ready to launch to our camera club.
http://www.photosbymarkharris.com/cmgalleryInstalled all the files using filezilla
Run the install.php process all works OK
I have set up a number of categories and albums as a test structure and all appears OK. However, when I click on users to setup new users in advance, I get this error
Critical error
There was an error while processing a database query...
In the logfile I get this error which means nothing to me.... help!
Dec 31, 2010 at 01:37 PM - While executing query 'SELECT user_id AS user_id, user_name AS user_name, user_email AS user_email, UNIX_TIMESTAMP(user_regdate) AS user_regdate, UNIX_TIMESTAMP(user_lastvisit) AS user_lastvisit, user_active AS user_active, COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota FROM `web125-dbase`.cpg15x_users AS u INNER JOIN web125-dbase.cpg15x_usergroups AS g ON u.user_group = g.group_id LEFT JOIN web125-dbase.cpg15x_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;' in bridge/udb_base.inc.php on line 230 the following error was encountered:
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 '-dbase.cpg15x_usergroups AS g ON u.user_group = g.group_id LEFT JOIN web125-dbas' at line 1I would welcome your guidance and suggestions for next steps...
Thanks
Mark