Skip to Content Skip to Menu

SQL error when going to php 5.3 and uddeIM upgrade

  • JLW
  • JLW
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 2
12 years 6 months ago - 12 years 6 months ago #199561 by JLW
SQL error when going to php 5.3 and uddeIM upgrade was created by JLW
I upgraded from php 5.2 to php 5.3 for my existing Joomla 1.5.26 site, and the following error messages appeared throughout Kunena Forum:
Code:
Deprecated: Assigning the return value of new by reference is deprecated in <span>/</span>home<span>/</span>... /public_html/plugins/content/uddeim_pms_contentlink.php on line 50

So I figured it was time to upgrade my uddeIM. So I installed 2.7 (the version for J 1.0 & 1.5), and got the following error message:
Code:
SQL error when attempting to save a messageDB function failed with error number 1054 Unknown column 'systemflag' in 'field list' SQL=INSERT INTO jos_uddeim (fromid, toid, toread, message, datum, systemflag, disablereply, systemmessage, totrashoutbox, totrashdateoutbox) VALUES (62, 62, 0, 'Welcome to uddeIM! You have succesfully installed uddeIM. Try viewing this message with different templates. You can set them in the administration backend of uddeIM. uddeIM is a project in development. If you find bugs or weaknesses, please write them to me so that we can make uddeIM better together. Good luck and have fun!', 1336287403, 1, 1, 'uddeIM', 1, 1336287403) SQL = INSERT INTO jos_uddeim (fromid, toid, toread, message, datum, systemflag, disablereply, systemmessage, totrashoutbox, totrashdateoutbox) VALUES (62, 62, 0, 'Welcome to uddeIM! You have succesfully installed uddeIM. Try viewing this message with different templates. You can set them in the administration backend of uddeIM. uddeIM is a project in development. If you find bugs or weaknesses, please write them to me so that we can make uddeIM better together. Good luck and have fun!', 1336287403, 1, 1, 'uddeIM', 1, 1336287403)

I then installed all the modules and CB plugins without incident.

But the error messages haven't gone away. And line 50 says:
Code:
$pluginparams =& new mosParameters( $mambot->params );

What should I do next?
--- Jordan
Accordionist.org
ElectronicMother.com
Last edit: 12 years 6 months ago by JLW.

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
12 years 6 months ago - 12 years 6 months ago #199570 by slabbi
Replied by slabbi on topic Re: SQL error when going to php 5.3 and uddeIM upgrade
First:
You have not updated your database when you upgraded uddeIM. Check the README and the FAQ.

Second:
PHP 5.3 introduced a few changes (Deprecated: Assigning the return value
of new by reference is deprecated). You can remove the "&" in line 50. UddeIM 2.7 has this problem already fixed.
uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer
Last edit: 12 years 6 months ago by slabbi.
The following user(s) said Thank You: JLW

Please Log in or Create an account to join the conversation.

  • JLW
  • JLW
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 2
12 years 6 months ago - 12 years 6 months ago #199586 by JLW
Replied by JLW on topic Re: SQL error when going to php 5.3 and uddeIM upgrade
Thank you. I found and ran the SQL snippet to go from 2.0 to 2.7; and then reinstalled all the uddeIM modules and plugins for good measure.

Everything on the site now looks good.

However, today when I tried to log in, got a server error that says:

[code]Fatal Error: Cannot redeclare uddeIMpmsLink15() (previously declared in .../public_html/plugins/content/uddeim_contentlink.php:36) in plugins/content/uddeim_pms_contentlink.php on line 23

The error was detected in the Content - Uddeim Pms Contentlink Plugin.[code]

I get that internittently.


ANy ideas?
--- Jordan
Accordionist.org
ElectronicMother.com
Last edit: 12 years 6 months ago by JLW.

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
12 years 6 months ago #199587 by slabbi
Replied by slabbi on topic Re: SQL error when going to php 5.3 and uddeIM upgrade
There is still one plugin, module or CB plugin that has not been updated to uddeIM 2.7.
uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

  • JLW
  • JLW
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 2
12 years 6 months ago - 12 years 6 months ago #199589 by JLW
Replied by JLW on topic Re: SQL error when going to php 5.3 and uddeIM upgrade
Thank you.

In the Extension Manager, the mod_uddeim, mod_uddeim_mailbox, and mod_uddeim_satatistics show up as 2.7 with a date of 4/1/12 and a red X indicating that legacy mode is required. (And indeed I do have legacy mode enabled.)

Ditto for the enabled plug-in: "uddeIM content link"
and also for the disabled plug-in: "uddeim PMS content link" (2.0 dated 3/1/10)
which I'll try uninstalling manually next, in case it's causing the problem even while disabled.

The CB plugins list shows:

PMS uddeIM Inbox in directory pms.showinbox
PMS uddeIM in directory pms.uddeim
uddeIM Profilelink in directory pms.uddeim.profilelink
uddeIM Blocking Plugin in directory blocking.uddeim
Private Messaging System (uddeIM PMS) in directory pms.uddeim

No version numbers nor dates are shown. But if I open them, the last one shows 2.0 and the second one show 2.0. So I uninstalled the second one.

Then I emptied the Joomla cache.

I'm still getting the error message, but perhaps it's now in my browser's cache. Will check that next.

Thanks for your attention.
--- Jordan
Accordionist.org
ElectronicMother.com
Last edit: 12 years 6 months ago by JLW.

Please Log in or Create an account to join the conversation.

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
12 years 6 months ago #199605 by slabbi
Replied by slabbi on topic Re: SQL error when going to php 5.3 and uddeIM upgrade
Regarding the "red cross" you will find the explanation and how to fix this in the FAQ (uddeIM provides a build-in function for that Joomla bug).

As I said before you have to upgrade _ALL_ uddeIM modules, plugins and CB plugins, also the disabled ones.
uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, slabbi, krileon
Powered by Kunena Forum