Manually created database error

[Pablo]

Note that this has nothing to do with the software.

Did you get a response from your webhost?

[Phillip911]

Yea, I know the error not related with the software. I just want find who have experience to solve this issue.

They replied

The default date format in this server is same as Singapore time and date

I have no idea about it

[Pablo]

I have no idea about it

Maybe they can tell you?

[Phillip911]

Maybe they can tell you?

I think they also don't know what i'm asking and what is it..... RIP

A lesson for me, DON'T BUY CHEAP SERVER

[Phillip911]

Pablo, Did you have any suggesting on web hosting provider that 100% combability with WWB without configure this kind of issue ?

[Pablo]

This is not a matter of compatibility.
You should be able to create the databases with any web host that supports MYSQL.

However, you will need to figure out what the default date format for the server is.
Or ask someone who has more knowledge about MySQL.

[Phillip911]

A Good news is, i success create the SQL manually

Code: Select all

-- 

-- Table structure for table `CMS_PAGES`

-- 

CREATE TABLE `CMS_PAGES` (

`id` int(10) unsigned NOT NULL auto_increment,

`category_id` int(11) NOT NULL,

`name` varchar(255) NOT NULL,

`content` text NOT NULL,

`home` tinyint(1) NOT NULL default '0',

`visible` tinyint(1) NOT NULL,

`create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`created_by` varchar(255) NOT NULL,

`last_update_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`last_update_by` varchar(255) NOT NULL,

`views` int(11) NOT NULL,

`menu_index` smallint(4) NOT NULL,

`url` varchar(255) NULL,

`extra_data` varchar(255) NULL,

`title` VARCHAR(100), 

`description` VARCHAR(255), 

`keywords` VARCHAR(255), 

`seo_friendly_url` VARCHAR(100),

`parent_id` int(11) DEFAULT NULL,

`search_index` int(1) DEFAULT '1',

PRIMARY KEY  (`id`));
 

 
-- 

-- Table structure for table `CMS_SEARCH_WORDMATCH`

-- 

CREATE TABLE `CMS_SEARCH_WORDMATCH` (

`page_id` int(10) unsigned NOT NULL,

`word_id` int(10) unsigned NOT NULL,

PRIMARY KEY  (`page_id`,`word_id`));

 

 

-- 

-- Table structure for table `CMS_SEARCH_WORDS`

-- 

CREATE TABLE `CMS_SEARCH_WORDS` (

`id` int(10) unsigned NOT NULL auto_increment,

`word` varchar(50) NOT NULL,

PRIMARY KEY  (`id`)) ;

BUT, The bad news is. I still getting the same error while i login with the admin.......
anymore idea ?

[Pablo]

What is the error?
What is your configuration?
Can you please be more specific?

[Phillip911]

This is the error

Invalid query: Invalid default value for 'last_update_date'

I have done created the SQL manually, while i try login to the cms admin. Get this error.
The code i use for create the SQL have send above

[Pablo]

It looks like it's still not configured correctly.
This is a server related issue.

[wwonderfull]

just dropping an opinion if you want you can get a webhost from hostinger(dot)com or whois(dot)com or even bluehost(dot)com all of them have a decent price with good and compatible service.

[Phillip911]

just dropping an opinion if you want you can get a webhost from hostinger(dot)com or whois(dot)com or even bluehost(dot)com all of them have a decent price with good and compatible service.

Thanks for suggestion

[WWBman]

The sql generated by wwb contains:
last_update_date TIMESTAMP NOT NULL,
so the issue could be the sql mode NO_ZERO_DATE.
I got the same error when using XAMPP.
In the SQL file my.ini there is:
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
When I changed this to:
sql_mode=NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION
the table was created successfully with no error message.

If you can find the equivalent file on your server and remove the NO_ZERO_DATE then this might solve the problem.

BUT, I am no expert in SQL options and although this seems to work on my XAMPP system, it may not be applicable on a 'live' server.
On my Linux server I do not get the error message.

[Phillip911]

The sql generated by wwb contains:
last_update_date TIMESTAMP NOT NULL,
so the issue could be the sql mode NO_ZERO_DATE.
I got the same error when using XAMPP.
In the SQL file my.ini there is:
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION
When I changed this to:
sql_mode=NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION
the table was created successfully with no error message.

If you can find the equivalent file on your server and remove the NO_ZERO_DATE then this might solve the problem.

BUT, I am no expert in SQL options and although this seems to work on my XAMPP system, it may not be applicable on a 'live' server.
On my Linux server I do not get the error message.

Sorry bro, i tried. Still not from me. But i found a solution.

Use Hostinger... All my issue manage to solve, no even need to create the database manually.

Thanks for help