JEvents 3.1 (Free Access)

500 - Column count doesn't match value count at row 1 SQL=..  Topic is solved

Forum for JEvents 3.1 for Joomla 3.x and 2.5.
Forum rules
When requesting support please follow these steps:

1. Update all JEvents add on's first, via the Joomla! Updater
2. Copy and Paste the JEvents Support Information from the JEvents Control Panel.
3. If you get a 500 error OR white page, enable Maximum Error Reporting in Joomla! Global Config and visit the page again, this should give you a more detailed error and help us provide a prompt response.

Postby Rossano » Tue Feb 12, 2013 1:38 pm

Buon giorno a tutti

Sono nuovo di questo Forum, ma anche di Joomla in genere.

Fino alla settimana scorsa JEvents mi funzionava tutto, ora dopo che si cerca di salvare un nuovo evento, ma anche se si cerca di modificarne uno vecchio, viene il messaggio di errore in oggetto.

Cosa può essere successo?

Grazie e a presto
Rossano
Rossano
 
Posts: 4
Joined: Tue Feb 12, 2013 9:36 am

Postby Geraint » Tue Feb 12, 2013 3:02 pm

Please provide detailed version information for Joomla, JEvents and PHP

Also your error message is truncated - please provide the whole error message.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42795
Joined: Fri Feb 15, 2008 6:14 pm

Postby Rossano » Tue Feb 12, 2013 3:42 pm

Joomla 2.5
JEvents 3.0.7
phpMyAdmin 3.5.4

Messaggio errore completo:
500 - Column count doesn't match value count at row 1 SQL=INSERT INTO `rlpv1_finder_tokens` (`term`,`stem`,`common`,`phrase`,`weight`,`context`) VALUES ('xx', 'xx', 0, 0, 0,2, 1)

Grazie
Rossano
 
Posts: 4
Joined: Tue Feb 12, 2013 9:36 am

Postby Tonyp » Tue Feb 12, 2013 8:27 pm

Hello Grazie,

Can you try disabling the Joomla! Finder plugin?

Regards
Tony
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23698
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby Rossano » Fri Feb 15, 2013 8:16 am

Non ho installato Joomla Finder

Altri consigli?

Rossano
Rossano
 
Posts: 4
Joined: Tue Feb 12, 2013 9:36 am

Postby carcam » Fri Feb 15, 2013 11:22 am

It's installed by default in all Joomla! 2.5 installations. Please check it.
¿Sabías que tenemos soporte en español para los miembros del Club de JEvents? ¡ÚNETE AHORA!
User avatar
carcam
Team Staff
 
Posts: 7094
Joined: Wed Aug 06, 2008 7:50 pm
Location: Almería

Postby Rossano » Fri Feb 15, 2013 11:52 am

I disabled the following plug-ins from the type "Finder":
Motore di ricerca - Categorie
Motore di ricerca - Contatti
Motore di ricerca - Contenuti
Motore di ricerca - Newsfeeds
Motore di ricerca - Link web
But the problem was not solved.

Then I disabled: Smart Search - Jevents, and now my JEvents calendar works well and also I'm still able to search contents in my application.

Thanks
Rossano
Rossano
 
Posts: 4
Joined: Tue Feb 12, 2013 9:36 am

Postby carcam » Fri Feb 15, 2013 12:27 pm

Sorry about the confusion, yes Smart Search was the problem.
¿Sabías que tenemos soporte en español para los miembros del Club de JEvents? ¡ÚNETE AHORA!
User avatar
carcam
Team Staff
 
Posts: 7094
Joined: Wed Aug 06, 2008 7:50 pm
Location: Almería

Postby Orpheus2510 » Tue Jun 18, 2013 8:15 pm

I've got the same error on one page - disabling JEvents finder solved the issue. It seems, as if there is a problem with that plugin under certain conditions (my site was migrated rom J1.5 to J2.5).
Best regards, Orpheus2510
Orpheus2510
 
Posts: 48
Joined: Fri May 04, 2012 1:10 pm

Postby Geraint » Wed Jun 19, 2013 6:50 am

the only place that data is inserted in the #__finder_tokens table is in the file administrator/components/com_finder/helpers/indexer/indexer.php at lines 1213-1240 for Joomla 2.5 and the file administrator/components/com_finder/helpers/indexer/driver/mysql.php at lines 580-607. In either case the code looks watertight and should not generate a different number of columns.

Can you give me your error message in more detail and cut and paste the relevant lines of code from the file mentioned above so I can see what you have on your server.

Thanks
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42795
Joined: Fri Feb 15, 2008 6:14 pm

Next

Return to JEvents 3.1 (Free Access)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: No registered users