joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi

rork
Topic Author
Offline
Senior Member

11 years 4 months ago - 11 years 4 months ago #38578 by rork

joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi was created by rork

Bonjour,
j'ai 4 sites en 1.5 (encore) à passer en 2.5. J'ai suivi le conseil "- FLEXIcontent 2.0.x pour J2.5 est compatible avec FC version 1.5.x pour J1.5, structure de la base de données, formats des données et configuration. Donc, si vous faites évoluer Joomla 1.5 vers la version 2.5 et installez FC v2.0, cela va fonctionner, mais certains endroits ont besoin de mise à jour :" pour un premier site.
J'ai corrigé user en users dans la configuration.

J'ai retrouvé tous mes petits, j'ai juste des erreurs dans "Auteurs" et "Search Indexes" :
Auteurs :

Table 'xxx.jnew_flexicontent_authors_ext' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS a.*, COUNT(i.id) as itemscount, s.userid IS NOT NULL AS loggedin FROM jnew_users AS a LEFT JOIN jnew_flexicontent_authors_ext AS ue ON a.id = ue.user_id LEFT JOIN jnew_content AS i ON i.created_by = a.id LEFT JOIN jnew_session AS s ON s.userid = a.id GROUP BY a.id HAVING ( itemscount > 0 ) ORDER BY a.name LIMIT 0, 50
Warning: Invalid argument supplied for foreach() in /xxx/administrator/components/com_flexicontent/views/users/view.html.php on line 259

Warning: Invalid argument supplied for foreach() in /xxx/administrator/components/com_flexicontent/views/users/view.html.php on line 266

search indexes :

getData(): SQL QUERY ERROR:
Table 'xxx.jnew_flexicontent_advsearch_index' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS ai.sid FROM jnew_flexicontent_advsearch_index as ai JOIN jnew_content as a ON ai.item_id=a.id JOIN jnew_flexicontent_items_ext as ext ON ext.item_id=a.id JOIN jnew_flexicontent_fields_type_relations as rel ON rel.field_id=ai.field_id AND rel.type_id=ext.type_id JOIN jnew_flexicontent_fields as f ON ai.field_id=f.id ORDER BY a.title ASC LIMIT 0, 50

NOTE : Database limits minimum search word length (ft_min_word_len) to 4

Je dois aller dans la base sql ?
Aurais-je dû faire la mise à jour 2.0 avant de migrer ?
Bref, j'ai essayé de comprendre sur les forums, j'ai rien trouvé encore de clair pour me faire avancer !
Si vous avez une piste...
Merci

Yannick Bernard Darlington
Perdu dans le Limousin

I want to believe, but winter is coming!

Last edit: 11 years 4 months ago by rork.

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

ggppdk
Offline
Administrator

11 years 4 months ago #38581 by ggppdk

Replied by ggppdk on topic joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi

Hello,
did the installation finish?

try re-installing package v2.0.2 package
or better v2.0.3beta2 (it is stable with some minor bug-fixes)

(do not uninstall just reinstall the package)

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

rork
Topic Author
Offline
Senior Member

11 years 4 months ago #38582 by rork

Replied by rork on topic joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi

i finish the installation, with FLEXIcontent version 2.0.2 r1680.
i install again the same version ?
i upload the 2.0.3 now

I want to believe, but winter is coming!

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

rork
Topic Author
Offline
Senior Member

11 years 4 months ago #38584 by rork

Replied by rork on topic joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi

i hace install the last version, FLEXIcontent version 2.0.3 beta2 r1686.
i have rhe same message error in auteurs et search indexes :

Table 'xxx.jnew_flexicontent_authors_ext' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS a.*, COUNT(i.id) as itemscount, s.userid IS NOT NULL AS loggedin FROM jnew_users AS a LEFT JOIN jnew_flexicontent_authors_ext AS ue ON a.id = ue.user_id LEFT JOIN jnew_content AS i ON i.created_by = a.id LEFT JOIN jnew_session AS s ON s.userid = a.id GROUP BY a.id HAVING ( itemscount > 0 ) ORDER BY a.name LIMIT 0, 50
Warning: Invalid argument supplied for foreach() in /xxx/administrator/components/com_flexicontent/views/users/view.html.php on line 259

Warning: Invalid argument supplied for foreach() in /xxx/administrator/components/com_flexicontent/views/users/view.html.php on line 266

Warning: Invalid argument supplied for foreach() in /xxx/administrator/components/com_flexicontent/views/users/view.html.php on line 267

getData(): SQL QUERY ERROR:
Table 'xxx.jnew_flexicontent_advsearch_index' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS ai.sid FROM jnew_flexicontent_advsearch_index as ai JOIN jnew_content as a ON ai.item_id=a.id JOIN jnew_flexicontent_items_ext as ext ON ext.item_id=a.id JOIN jnew_flexicontent_fields_type_relations as rel ON rel.field_id=ai.field_id AND rel.type_id=ext.type_id JOIN jnew_flexicontent_fields as f ON ai.field_id=f.id ORDER BY a.title ASC LIMIT 0, 50

NOTE : Database limits minimum search word length (ft_min_word_len) to 4

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /xxx/libraries/joomla/database/database/mysqli.php on line 263

Warning: Invalid argument supplied for foreach() in /xxx/administrator/components/com_flexicontent/models/search.php on line 91

I want to believe, but winter is coming!

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

ggppdk
Offline
Administrator

11 years 4 months ago #38585 by ggppdk

Replied by ggppdk on topic joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi

If the tables are not created, then you can

open file:

administrator/components/com_flexicontent/installation/install.mysql.utf8.sql

-- add execute it's contents in phpmyadmin
(just replace #__ with you joomla prefix e.g. jos_)

e.g. execute in phpmyadmin:

Code:

CREATE TABLE IF NOT EXISTS `jos_flexicontent_advsearch_index` (
  `sid` int(11) NOT NULL auto_increment,
  `field_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `extraid` int(11) NOT NULL,
  `search_index` longtext NOT NULL,
  `value_id` varchar(255) NULL,
  PRIMARY KEY (`field_id`,`item_id`,`extraid`),
  KEY `sid` (`sid`),
  KEY `field_id` (`field_id`),
  KEY `item_id` (`item_id`),
  FULLTEXT `search_index` (`search_index`),
  KEY `value_id` (`value_id`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

CREATE TABLE IF NOT EXISTS `jos_flexicontent_authors_ext` (
  `user_id` int(11) unsigned NOT NULL,
  `author_basicparams` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `author_catparams` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

the above code uses jos_ as prefix please change it to match your prefix

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

rork
Topic Author
Offline
Senior Member

11 years 4 months ago #38586 by rork

Replied by rork on topic joomla 1.5 à joomla 2.5 par Jupdate puis retour de flexi

Well done !
nothing to comment, rapidely and clearly support, i'm very enjoy. I has some stress to used flexi after a migration and update, why i have 4 website in 1.5 again now. But, it's a good extension for multi-critère, complex but very self-evolutive, then cool !
good end of week-end !
Yannick

I want to believe, but winter is coming!

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