1
snow77
PictureUrl and mySql compatability
  • 2007/11/13 5:03

  • snow77

  • Just can't stay away

  • Posts: 864

  • Since: 2003/7/23


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.

2
Catzwolf
Re: PictureUrl and mySql compatability
  • 2007/11/13 9:05

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


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

3
philou
Re: PictureUrl and mySql compatability
  • 2007/11/13 13:12

  • philou

  • Quite a regular

  • Posts: 384

  • Since: 2002/5/6 8


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

4
philou
Re: PictureUrl and mySql compatability
  • 2007/11/13 13:27

  • philou

  • Quite a regular

  • Posts: 384

  • Since: 2002/5/6 8


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

5
snow77
Re: PictureUrl and mySql compatability
  • 2007/11/13 20:31

  • snow77

  • Just can't stay away

  • Posts: 864

  • Since: 2003/7/23


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.

Login

Who's Online

165 user(s) are online (99 user(s) are browsing Support Forums)


Members: 0


Guests: 165


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits