xoops forums

snow77

Just can't stay away
Posted on: 2007/11/13 5:03
snow77
snow77 (Show more)
Just can't stay away
Posts: 864
Since: 2003/7/23
#1

PictureUrl and mySql compatability

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.

Catzwolf

Home away from home
Posted on: 2007/11/13 9:05
Catzwolf
Catzwolf (Show more)
Home away from home
Posts: 1392
Since: 2007/9/30
#2

Re: PictureUrl and mySql compatability

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

philou

Quite a regular
Posted on: 2007/11/13 13:12
philou
philou (Show more)
Quite a regular
Posts: 384
Since: 2002/5/6 8
#3

Re: PictureUrl and mySql compatability

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
Resized Image - - Resized Image

philou

Quite a regular
Posted on: 2007/11/13 13:27
philou
philou (Show more)
Quite a regular
Posts: 384
Since: 2002/5/6 8
#4

Re: PictureUrl and mySql compatability

It's ok for me....

can you try these version :
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
Resized Image - - Resized Image

snow77

Just can't stay away
Posted on: 2007/11/13 20:31
snow77
snow77 (Show more)
Just can't stay away
Posts: 864
Since: 2003/7/23
#5

Re: PictureUrl and mySql compatability

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.