Topics

User Functions

Events

There are no upcoming events

What's New

Stories last 2 weeks

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

Downloads last 2 weeks


Welcome to Geeklog Wednesday, February 10 2016 @ 11:12 PM EST

 Forum Index > Support > General Geeklog Support New Topic Post Reply
 MySQL upgrade
Prev Topic Next Topic
   
::Ben
 11/15/12 04:10AM (Read 511 times)  

Full Member

Status: offline
Forum User

Registered: 01/14/05
Posts: 1556
Location:la rochelle, France
What is the best choice for geeklog 1.8.1 and 2.0 ?

MySQL 4.1 October 23, 2004
MySQL 5.0 October 24, 2005
MySQL 5.1 December 8, 2008
MySQL 5.5 December 2010

Ben

I'm available to customise your themes or plugins for your Geeklog CMS
 
Profile Email Website
 Quote
Dirk
 11/15/12 04:21AM  

Admin

Status: offline
Site Admin

Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Geeklog 1.8.1 has a few issues with MySQL 5.5 (we should really do a 1.8.2 release to fix those). Geeklog 2.0.0 should work fine with MySQL 5.5.

bye, Dirk
 
Profile Email Website
 Quote
::Ben
 11/15/12 08:21AM  

Full Member

Status: offline
Forum User

Registered: 01/14/05
Posts: 1556
Location:la rochelle, France
Thanks for the answer. Then I will take MySQL 5.1

Ben

I'm available to customise your themes or plugins for your Geeklog CMS
 
Profile Email Website
 Quote
::Ben
 11/18/12 10:45AM  

Full Member

Status: offline
Forum User

Registered: 01/14/05
Posts: 1556
Location:la rochelle, France
I noticed few issues with plugins after upgrading from mysql 4.1 to 5.1

Maps plugin: call-time pass-by-reference in functions.php
Paypal plugin: cannot re-assign auto-global variable in proversion.php
Classifieds plugin: cannot re-assign auto-global variable in proversion.php and lib-edit.php

Those will be fix in the next releases.

Downloads plugin and Filemanager plugin: incorrect key file for tables: gl_downloads, gl_filemgmt_filedetail. I needed to drop table and import a backup

Mediagallery plugin: in functions.php line 949 I changed

PHP Formatted Code
From
$_MG_USERPREFS = MG_getUserPrefs();

To
$_MG_USERPREFS[] = MG_getUserPrefs();


Dokuwiki plugin is not working. I'm still investigating on this one.

Ben

I'm available to customise your themes or plugins for your Geeklog CMS
 
Profile Email Website
 Quote
Content generated in: 3.45 seconds New Topic Post Reply
 All times are EST. The time is now 11:12 PM.
Normal Topic Normal Topic
Sticky Topic Sticky Topic
Locked Topic Locked Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content