Does Pligg support MySQL5?

[lance]

I am using php5 and mysql5 and found pligg not working.
When I submit a story there are a lot of sql errors. Can somebody
help me with this?
My test site is here
http://ss.gg
You can use this username if you are too lazy to register one.
user:tester
pw:tester

Many thanks!

[lance]

I get this error in step 2
SQL/DB Error -- [Incorrect datetime value: '1970-01-01 08:00:00' for column 'link_published_date' at row 1]
SQL/DB 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 '' at line 1]

and this in step 3

story details
SQL/DB 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 'AND user_id=link_author' at line 1]
SQL/DB 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 'AND vote_value > 0 AND vote_user_id=16' at line 1]
SQL/DB 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 ' 10, '218.80.224.9')' at line 1]
SQL/DB 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 '' at line 1]
SQL/DB 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 'AND user_id=link_author' at line 1]

[bluetiger]

I'm getting similar errors to these. I downgraded from MySQL 5.0 to MySQL 4.1 just to see if that would help. I'm unable to use pligg 7.2/mollio-beat 1.3 at all in Windows/IIS because I get SQL errors any time I try to save to the database.

Example:

SQL/DB 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 ' user_url='2', user_aim='', user_msn='', user_yahoo='', user_gtalk='', user_skyp' at line 1]

TIA for any pointers!

[lance]

Oh. Then the error should be IIS and not MySQL...

[bluetiger]

The problem was fixed by upgrading to the latest nightly release:

http://www.pligg.com/forum/showthread.php?t=1254

[lance]

I installed the nightly build 138 but still got some problem

at step 2
[Field 'link_title' doesn't have a default value]

at step 3
story details
incorrect key
try again
incomplete title or text
try again

anybody can help me? Thanks!

[bluetiger]

Does this thread help?

http://www.pligg.com/forum/showthrea...ght=link_title

[lance]

I already used that and created the links table. The problem is I can not insert into it...

[bluetiger]

I'm sorry, I'm not sure what to tell you... I'm new to Pligg and upgrading to the latest release resolved that issue for me. :-/

[lance]

Could you tell me your server configurations? Such as apache or iis, php version and mysql version, thanks!