Dragonfly CMS v9 ⇒ Modules & Blocks ⇒ A Database Error Has Occurred ⇒ Community Forums ⇒ CPG Dragonfly™ CMS

A Database Error Has Occurred Reply to topic

HTML Offline Joined: Jan 08, 2014 Posts: 12 0 👍 / 0 👎	Thu Jan 16, 2014 5:14 am Error occurs when viewing profile of a certain member. Other profiles load normally. A database error has occurred The webmaster has been notified of the error includes/db/db.php CMS Warning line 70: On /index.php?name=Your_Account&profile=4 While executing query "SELECT rank_title, rank_image FROM data_bbranks WHERE " the following error occured: 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 2 In: /home/forumsx5/public_html/modules/Your_Account/userinfo.php on line: 73 73. WHERE '.$sql, SQL_NUM); 74. $poster_rank = ($rank_image) ? '<img src="'.$rank_image.'" 75. alt="'.$poster_rank.'" title="'.$poster_rank.'" />' : $poster_rank; Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): Windows 8 / Apache: 2.2.24 / MySQL: 5.1.71 / PHP: 5.4.17 / Dragonfly: LATEST VERSION
HTML Offline Joined: Jan 08, 2014 Posts: 12 0 👍 / 0 👎	Thu Jan 16, 2014 3:28 pm Fixed. I just suspended the user and left it like that. Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): Windows 8 / Apache: 2.2.24 / MySQL: 5.1.71 / PHP: 5.4.17 / Dragonfly: LATEST VERSION
Eestlane Offline Joined: Apr 06, 2005 Posts: 1421 Location: Estonia, Tartu 0 👍 / 0 👎	Sat Jan 18, 2014 12:07 am 1) Your code editor probably has word wrapping on, because lines 74 & 75 are actually one line, so these aren't really lines 74 & 75. Did this user have a special user rank set (not post count based)? And if so, what is the name of that rank? Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): -
All times are UTC Post new topic Reply to topic Forum Index ⇒ Modules & Blocks Page 1 of 1