0
Welcome Guest! Login
0 items Join Now

ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down. Read our Farewell Blog Post for more details.

Errors with dzcpCMS and MySQL Strict

Last Post
Search Topic

  • Errors with dzcpCMS and MySQL Strict

    Posted 14 years 6 months ago
    • Hello community!

      My problem isn't Joomla/phpBB related, but i thought i could give it a try, because you guys here have much experience with PHP/MySQL (i guess :P ).

      So I was using the DZCP (Devil'z Clanportal) for my clansite, hosted by a freehoster. Now we were tired of having advertisement on the site and also wanted a faster site, so we decided to move our site to a sponsor's webspace. All worked fine, until i tried out to post something in the forums. Also, when i try to add users, or write something in the guestbook, i get a similar error:
      MySQL-Query failed:
 
     * ErrorNo = 1364
     * Error = Field 'edited' doesn't have a default value
     * Query = INSERT INTO forumposts SET `kid` = '1', `sid` = '70', `date` = '1291545573', `nick` = '', `email` = '', `hp` = '', `reg` = '1', `text` = '
 
       Hello everyone, im replying to a forumpost!
       ', `ip` = 'xxx.xxx.xxx.xxx'
      (I removed my IP)

      I googled the error#, and found out it has to do with the server running in MySQL Strict mode. I talked to my sponsor, but he doen't want to put the server out of strict mode. "However, it should be quite easy to fix, by giving 'edited' a default value", he said.
      So now, I have no idea what i should do. Shall I find out how to give this field a default value, or will this cause even more problems?
      I hope you can give me a hint.

      Thanks in advance!
    #589975

Time to create page: 0.080 seconds