| Coppermine Simple Forum Plugin |
|
| Stramm |
|
||
Registered Post: 1 Registered: Oct 10 2008 |
Hi Foulo, I tried to install your plugin (beta 1a) on a win box running iis and MySQL 5.0.51a. The sql isn't addd properly cause of errors in install.sql. At least this mysql version doesn't like the syntax and/ or spits out errors when trying create a new thread That's the problematic entries so far `poster_email` tinytext NOT NULL default '0', //complained about default `modified_name` tinytext NOT NULL, // complained about NOT NULL ALTER TABLE `CPG_users` ADD `fr_signature` text NOT NULL DEFAULT ''; // here it didn't like the default this is working `fr_signature` text NOT NULL, `poster_email` tinytext, `modified_name` tinytext, I haven't looked any further in it yet... btw, thanks for the plugin |
||
| foulu |
|
||
Administrators Post: 56 Registered: Sep 07 2008 |
Oh. I got it. I will fix it in my new release. Thanks ! |
||
| joseosun |
|
||
Registered Post: 1 Registered: Jun 29 2010 |
Hi, I experience the same error. When a new thread is created, the following error appears: Array ( [0] => Error Number: 1364 [1] => Field 'poster_email' doesn't have a default value [2] => INSERT INTO cpg15x_fr_messages (icon, subject, body, poster_time, poster_id, poster_name, poster_ip, smileys_enabled, topic_id, board_id) VALUES ('icon1', 'Test', 'Nächster Versuch', 1277849861, '2', 'Jose', '10.138.71.159', 1, 3, 1) ) The version number of Simple Forum is "CPG Simple Forum (forum): v2.1 BETA" Do you have any suggestions? TIA, José |
||
|
|
|