Support ⇒ Modules & Blocks ⇒ A Database Error Has Occurred ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexModules & Blocks

A Database Error Has Occurred Reply to topic


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


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


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


Jump to: