The module PictureUrl seems to present a problem with mySql 5:

On one pc I have:
# PHP Version : 5.2.3
# MySQL Version : 5.0.45

and the following error appears after clicking submit on Create a picture:

Erreur requete :INSERT INTO x2_pictureurl (id, image, defaultimg, url_image, onmouseover, url_page, align, height, width, marginl, marginr, margint, marginb, repeat) VALUES ('','spotlight-computers.jpg', '1', '', '', 'http://localhost/xoops/', '', '', '', '', '', '', '', '')

Error number: 1064
Error message: 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 'repeat) VALUES ('','spotlight-computers.jpg', '1', '', '', 'http://localhost/xoo' at line 1

and the module does not work.

However on another pc I have:
# PHP Version : 5.2.3
# MySQL Version : 4.1.22

and the module does work there.

If you would like I could update the module to work on MySQL 5, just sent it to catzwolf@catzwolf.x10hosting.com and I will return a working copy (hopefully) to you Snow.

ATB

Catz

hello,
I'm the autor of this module....

I think this problem is due to the 'repeat' field. It's a reserved word in the MySQL 5

I do some changes and repost a corrected module

It's ok for me....

can you try these version :
http://www.philox.info/uploads/m_xv2_picturelurlv13.zip
and tell me if this is correct for you too ?

Php 5.2.3
Mysql 5.0.37

Thank you Catzwolf for offering the fix and thank you Philou for giving the new version.

The new version is working well in MySQL 5 now.