Jevents migration script wont work: Invalid argument error

[joomlaboy]

Warning: Invalid argument supplied for foreach() in /home/hachb0ex/public_html/dev/healing/upgradejevents.php on line 131
migrated categories
migrated main tables
updated category references
500 - Table 'hachb0ex_heal.j25_jevents_icsfile' doesn't exist SQL=UPDATE j25_jevents_icsfile set access=access+1

J1.5 Path: http://dev.dashboard.gr/healing/
J2.5 Path: http://dev.dashboard.gr/healing/jupgrade

also J2.5 Path: http://dev.dashboard.gr/heal/

Both J2.5 installations uses same DB.
User for J1.5 and J2.5 DB is the same, so there is full permissions on both.

[joomlaboy]

Since the instructions I have found in here, I can see one more jevents table in the joomla 2.5 database. it is the jevents_catmap. Should I drop it too ?

[Tonyp]

Drop all JEvents tables in Joomla 2.5.

Regards
Tony

[joomlaboy]

Hey, thanks for the replies.
All tables are dropped, but I still get the same errors

[joomlaboy]

SOLUTION:
Finally I figured it out!
So here is my solution for everyone has same issue.
As my server is not supporting the mysqli driver, I had to change the upgradejevents.php file at about line 77 :

Code: Select all

$this->config_old['driver'] = 'mysqli';

to

Code: Select all

$this->config_old['driver'] = 'mysql';

John

[Tonyp]

Hi John,

No problem I will update the script to include an option .

--Edit, please find attached a new copy which should pull the mysql driver from the old config.

Regards
Tony

[joomlaboy]

We are just before releasing the new j2.5 site... after migration.
Since the first migration, users added more events in the J1.5 site.
Now I did again the migrate of events... everything worked fine.

But... one issue... in monthly view, it only displays events from specific categories chosen from the Dynamic category selector. If I choose All, no event displayed...
any ideas ?
issue here: http://bit.ly/UvnhGg

[joomlaboy]

We are just before releasing the new j2.5 site... after migration.
Since the first migration, users added more events in the J1.5 site.
Now I did again the migrate of events... everything worked fine.

But... one issue... in monthly view, it only displays events from specific categories chosen from the Dynamic category selector. If I choose All, no event displayed...

Solution for this, for anyone might come to same issue:
Needed to re-do the associated menu item. I went in that menu item, reset its settings and save.
Then it worked.

[crowd]

Version Information

Code: Select all

Joomla : 2.5.8
component_com_jevents : 2.2.8
component_com_jevlocations : 2.0.16
module_mod_jevents_cal : 2.2.8
module_mod_jevents_latest : 2.2.5
module_mod_jevents_legend : 2.2.3
plugin_editors_jce : 2.2.9.1
plugin_jevents_jevlocations : 2.0.19
plugin_search_eventsearch : 2.2.0
plugin_search_jevlocsearch : 1.5.5
plugin_system_jcemediabox : 1.1.4


Code: Select all

Joomla : 1.5.26
component_com_jevents : 2.2.8
component_com_jevlocations : 2.0.16
module_mod_jevents_cal : 2.2.8
module_mod_jevents_filter : 2.2.0
module_mod_jevents_latest : 2.2.5
module_mod_jevents_legend : 2.2.3
module_mod_jevents_switchview : 1.5.5 b1770
plugin_editors_jce : 2.2.7.2
plugin_advcode_advcode : 1.5.7.13 (not enabled)
plugin_advlink_advlink : 1.5.7.13 (not enabled)
plugin_links_docmanlinks : 1.1.1 (not enabled)
plugin_links_joomlalinks : 1.2.1 (not enabled)
plugin_links_rokdownloads : 1.0.1 (not enabled)
plugin_links_zoo : 1.0.0 (not enabled)
plugin_browser_browser : 1.5.7.13 (not enabled)
plugin_caption_caption : 1.5.6.3 (not enabled)
plugin_filemanager_filemanager : 1.5.4.1 (not enabled)
plugin_fullpage_fullpage : 1.5.7.12 (not enabled)
plugin_help_help : 1.5.7.13 (not enabled)
plugin_iframe_iframe : 1.5.6.2 (not enabled)
plugin_imgmanager_imgmanager : 1.5.7.13 (not enabled)
plugin_imgmanager_ext_imgmanager_ext : 1.5.7.7 (not enabled)
plugin_media_media : 1.5.7.13 (not enabled)
plugin_mediamanager_mediamanager : 1.5.6.3 (not enabled)
plugin_paste_paste : 1.5.7.13 (not enabled)
plugin_spellchecker_spellchecker : 1.5.7.13 (not enabled)
plugin_templatemanager_templatemanager : 1.5.5.1 (not enabled)
plugin_editors_legacy : 2.2.8.4 (not enabled)
plugin_jevents_jevcalendar : 1.3.5
plugin_jevents_jevcatcal : 1.2.1 (not enabled)
plugin_jevents_jevfiles : 1.6.1
plugin_jevents_jevjcomments : 1.0
plugin_jevents_jevlocations : 2.0.19
plugin_search_eventsearch : 2.2.0
plugin_search_jevlocsearch : 1.5.5
plugin_system_jcemediabox : 1.1.4
plugin_system_langoverride : 1.3.4


Hello Support-Team,
I have also a problem by running the migration script:

Error Message:
500 - JDatabaseMySQLi::query: 1051 - Unknown table 'jomkas_jev_customfields3' SQL=DROP TABLE jomkas_jev_customfields3

J1.5 Path: http://www.os69.de/
J2.5 Path: http://www.os69.de/___hospiz25

In upgradejevents.php (Version 1_5, downloaded from this thread) I changed
define("NEWSITEPATH", "___hospiz25");

Migration script on root of joomla 1.5 installation
Also logged in as superadmin in jooomla 2.5 backend
tables jevents in Joomla 2.5 database deleted
Location Manager 2.0.16 on both sides installed
File Permission in both installations readable for all files

Migration Core with SPupgrade

Please help, what's wrong ?

Regards Oliver

[Tonyp]

Does the concerning table above exist in the 2.5 database?