Author Topic: 1.7.6 not working after server upgraded to mysql 5  (Read 15780 times)

0 Members and 1 Guest are viewing this topic.

Offline freediver

  • Pre-Newbie
  • Posts: 5
    • View Profile
1.7.6 not working after server upgraded to mysql 5
« on: July 16, 2008, 06:31:47 PM »
I have looked for a solution and I can't find one on the forum.

Here are some mistakes in my log file

16-Jul-2008 08:33:38] PHP Notice:  Undefined index:  cat_id in iincludes/functions.php on line 358
[16-Jul-2008 08:33:38] PHP Notice:  Undefined index:  image_id in includes/functions.php on line 362
[16-Jul-2008 08:33:38] PHP Notice:  Undefined index:  image_media_file in includes/functions.php on line 384
[16-Jul-2008 08:33:38] PHP Notice:  Undefined index:  image_id in includes/functions.php on line 405
[16-Jul-2008 08:33:38] PHP Notice:  Undefined index:  user_id in includes/functions.php on line 406
[16-Jul-2008 08:33:38] PHP Notice:  Undefined index:  image_name in includes/functions.php on line 409

The site is www.zoomwallpapers.com

Offline KurtW

  • 4images Guru
  • *******
  • Posts: 2.778
    • View Profile
    • Malediven-Bilder ~~Dreams~~
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #1 on: July 16, 2008, 07:07:24 PM »
Hi,

version 1.7.6 is mysql5 compatible  :wink:

i thing, you have mods included without mysql5 compatible code....

=> http://www.4homepages.de/forum/index.php?topic=10184.15


Kurt

Offline Acidgod

  • Moderator
  • 4images Guru
  • *****
  • Posts: 2.421
  • It's me?
    • View Profile
    • Flash-Webdesign
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #2 on: July 17, 2008, 12:20:27 AM »
it is a windows server?

open global.php

search
error_reporting(E_ERROR | E_WARNING | E_PARSE);

replace with
//error_reporting(E_ERROR | E_WARNING | E_PARSE);

Offline KurtW

  • 4images Guru
  • *******
  • Posts: 2.778
    • View Profile
    • Malediven-Bilder ~~Dreams~~
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #3 on: July 17, 2008, 06:09:25 AM »
And the other erros, e.g index.php:
Quote
An unexpected error occured. Please try again later.

An unexpected error occured. Please try again later.

Warning: Cannot modify header information - headers already sent by (output started at /home/prelovac/public_html/zoomwallpapers/includes/db_mysql.php:192) in /home/prelovac/public_html/zoomwallpapers/includes/sessions.php on line 101

Warning: Cannot modify header information - headers already sent by (output started at /home/prelovac/public_html/zoomwallpapers/includes/db_mysql.php:192) in /home/prelovac/public_html/zoomwallpapers/includes/sessions.php on line 101

An unexpected error occured. Please try again later.

An unexpected error occured. Please try again later.


Kurt

Offline freediver

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #4 on: July 17, 2008, 09:44:44 AM »
Thanks for brisk response.

The server is linux. The error_reporting tweak did not solve it.

"An unexpected error occured. Please try again later." is a message from script when a db error occurs. That is why the headers are already sent before the page comes.

The link KurtW provided contains patches that are already implemented in my source. I am using 1.7.6 and problems started when the server decided to upgrade to mysql 5.

The hosting says they can not inspect my "custom" script.

I do use some plugins but nothing fancy maybe one or two plugins. One is Photo of the Day.  The other one is for admin so it is not important.

Any help appreciated.




Offline Acidgod

  • Moderator
  • 4images Guru
  • *****
  • Posts: 2.421
  • It's me?
    • View Profile
    • Flash-Webdesign
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #5 on: July 17, 2008, 10:55:57 AM »
please post the code from the sessions.php...  :D

Offline freediver

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #6 on: July 17, 2008, 04:03:32 PM »

Offline Acidgod

  • Moderator
  • 4images Guru
  • *****
  • Posts: 2.421
  • It's me?
    • View Profile
    • Flash-Webdesign
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #7 on: July 17, 2008, 11:04:06 PM »
hmmm...

an the db_mysql.php please...

Offline freediver

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #8 on: July 18, 2008, 12:44:23 PM »
Here is the whole includes/

http://www.zoomwallpapers.com/src/includes.zip

I appreciate your time trying to figure out the problem.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #9 on: July 18, 2008, 03:06:58 PM »
In includes/functions.php find:
Code: [Select]
            FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
Replace with:
Code: [Select]
            FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
That should fix your Photo Of The Day mod, but if you installed other mods, you might want look for similar lines to change.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline freediver

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: 1.7.6 not working after server upgraded to mysql 5
« Reply #10 on: July 19, 2008, 03:22:36 PM »
The last tip was helpful and I replaced similar queries  (there was one - it was lightbox, dont know if that is standard part of 4images).

At the end I had to do REPAIR TABLE 4images_sessions

Thanks everyone for assistance.