Thread: DAtaBase error! Plz help

In Admin Panel when Clicking on Members in users shows this error
i deleted 2 members, showed this message and now clicking members show this error.

Error
Database query error
Query:
SELECT `ID`, `NickName`, `Email`, `Sex`, DATE_FORMAT(`LastLoggedIn`, '%m-%d-%y %H:%i' ) AS `LastLoggedInCur`, DATE_FORMAT(`LastReg`, '%m-%d-%y %H:%i' ) AS `LastReg`, `Status` FROM `Profiles` WHERE 1 ORDER BY LastLoggedIn deleted LIMIT 0, 30;
Mysql 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 'deleted LIMIT 0, 30' at line 10
Found error in file /home3/talkshaw/public_html/sn/admin/profiles.php
at line 224. Called db_res function
with erroneous argument #0

Debug backtrace:

Array
(
[1] => Array
(
[file] => /home3/talkshaw/public_html/sn/admin/profiles.php
[line] => 224
[function] => db_res
[args] => Array
(
[0] => SELECT `ID`,
`NickName`,
`Email`,
`Sex`,
DATE_FORMAT(`LastLoggedIn`, '%m-%d-%y %H:%i' ) AS `LastLoggedInCur`,
DATE_FORMAT(`LastReg`, '%m-%d-%y %H:%i' ) AS `LastReg`,
`Status`
FROM `Profiles`

WHERE 1 ORDER BY LastLoggedIn deleted LIMIT 0, 30;
)

)

)

What to Do???
really confused????

"ORDER BY LastLoggedIn deleted"

Check your profiles table for a "deleted" field.

Warm regards,
Smoge

Hi,

I don't think your problem is a Dolphin bug... but instead, due to a modification you added.


Anyways, you can download the latest 6.1.6 release here:

http://www.modmysite.com/dolphin-gen...-released.html

As you can see, in the standard Profiles table setup, there is no "deleted" field. It is something you added to your code.

Code:

CREATE TABLE `Profiles` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `NickName` varchar(255) NOT NULL default '',
  `Email` varchar(255) NOT NULL default '',
  `Password` varchar(32) NOT NULL default '',
  `Status` enum('Unconfirmed','Approval','Active','Rejected','Suspended') NOT NULL default 'Unconfirmed',
  `Couple` int(10) unsigned NOT NULL default '0',
  `Sex` varchar(255) NOT NULL default '',
  `LookingFor` set('male','female') NOT NULL default '',
  `Headline` varchar(255) NOT NULL default '',
  `DescriptionMe` text NOT NULL,
  `Country` varchar(255) NOT NULL default '',
  `City` varchar(255) NOT NULL default '',
  `DateOfBirth` date NOT NULL default '0000-00-00',
  `Featured` tinyint(1) NOT NULL default '0',
  `DateReg` datetime NOT NULL default '0000-00-00 00:00:00',
  `DateLastEdit` datetime NOT NULL default '0000-00-00 00:00:00',
  `DateLastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `DateLastNav` datetime NOT NULL default '0000-00-00 00:00:00',
  `PrimPhoto` int(10) unsigned NOT NULL default '0',
  `Picture` tinyint(1) NOT NULL default '0',
  `aff_num` int(10) unsigned NOT NULL default '0',
  `Tags` varchar(255) NOT NULL default '',
  `zip` varchar(255) NOT NULL default '',
  `EmailNotify` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `NickName` (`NickName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Warm regards,
Smoge