Jump to content

مشكلة في phpmyadmin سيرفرات حياه واقعية


Recommended Posts

سلام عليكم .. في مشكلة تواجهني لما احط قاعدة البيانات تبع الحياه الواقعيه في خادم لينكس لوحة php admin

يطلع كلام كذا

 

SQL query:

-- -- Database: `owl_mta` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` text, `password` varchar(32) NOT NULL, `salt` varchar(30) NOT NULL DEFAULT '1234567890', `email` varchar(100) NOT NULL, `registerdate` datetime DEFAULT CURRENT_TIMESTAMP, `lastlogin` datetime DEFAULT NULL, `ip` text, `admin` float NOT NULL DEFAULT '0', `supporter` float NOT NULL DEFAULT '0', `vct` float NOT NULL DEFAULT '0', `mapper` float NOT NULL DEFAULT '0', `scripter` float NOT NULL DEFAULT '0', `warn_style` int(1) NOT NULL DEFAULT '1', `hiddenadmin` tinyint(3) unsigned DEFAULT '0', `adminjail` tinyint(3) unsigned DEFAULT '0', `adminjail_time` int(11) DEFAULT NULL, `adminjail_by` text, `adminjail_reason` text, `muted` tinyint(3) unsigned DEFAULT '0', `globalooc` tinyint(3) unsigned DEFAULT '1', `friendsmessage` va[...]

MySQL said: Documentation

#1067 - Invalid default value for 'registerdate'

Link to comment
  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...