xoops forums

noisia

Not too shy to talk
Posted on: 2007/3/27 13:59
noisia
noisia (Show more)
Not too shy to talk
Posts: 123
Since: 2004/8/24
#1

XoopsGallery 1.3.4 album sorting problem

I installed xoopsgallery 1.3.4

When I moved the site to a new server, I encountered the following problem.

Suddenly the latest album always appears on the bottom. The second latest album appears to the top.

Moving albums also does not move correctly.

Can somebody help with this issue?

What I did was the following procedures:
- Install the complete XOOPS site to the new site
- move the MySQL database
- move the xoopsgallery cache folders from the old to the new site
- change permissions to the cache folders to 777

JMorris

XOOPS is my life!
Posted on: 2007/3/27 18:22
JMorris
JMorris (Show more)
XOOPS is my life!
Posts: 2722
Since: 2004/4/11
#2

Re: XoopsGallery 1.3.4 album sorting problem

What are the differences in PHP and MySQL between the two hosting environments?
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

noisia

Not too shy to talk
Posted on: 2007/3/28 2:27
noisia
noisia (Show more)
Not too shy to talk
Posts: 123
Since: 2004/8/24
#3

Re: XoopsGallery 1.3.4 album sorting problem

Hi JMorris,

Thank you for looking into the issue.

The difference between the server can be seen on the following phpinfo.php

Previous site was:
http://www.xxxx.com/phpinfo.php

Current site is:
http://www.xxxx.org/phpinfo.php

This problem has been bugging me for more than half a year, so hopefully I can solve it this time...

Best Regards,

Marco

JMorris

XOOPS is my life!
Posted on: 2007/3/28 2:42
JMorris
JMorris (Show more)
XOOPS is my life!
Posts: 2722
Since: 2004/4/11
#4

Re: XoopsGallery 1.3.4 album sorting problem

noisia,

I've edited your post because posting the URL to a phpinfo() page is a major security risk for you.

After looking at the specs on the two servers, the first thing that stands out to me is the MySQL client versions. The old server runs 3.x while the new server runs 5.x. This very well could be the source of the problem.

The XOOPS core is compatible with MySQL 5, but not all modules are. If possible, I'd recommend contacting the developer of XoopsGallery and asking them if their module is MySQL 5 compatible. Doing the following search for XoopsGallery MySQL 5 turned up 11,800 results, so I would say it's a safe bet the developer is aware that there are some issues.

HTH.

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

noisia

Not too shy to talk
Posted on: 2007/3/30 1:17
noisia
noisia (Show more)
Not too shy to talk
Posts: 123
Since: 2004/8/24
#5

Re: XoopsGallery 1.3.4 album sorting problem

Dear James,

Thank you very much for the security alert on exposing the PHPinfo. I have removed them from the server as well.

I will Google further on the MySQL 5.0 issue.

Thanks for your great support. (This is definitely why I like the XOOPS community)

Best Regards,

Marco