Getting error on Save

7 years 6 months ago #220062 by jase700
Getting error on Save was created by jase700
Error retrieving the data serious error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' FROM j17_users u LEFT JOIN j17_comprofiler c on (u.id=c.user_id)' at line 1 SQL=SELECT u.id,, FROM j17_users u LEFT JOIN j17_comprofiler c on (u.id=c.user_id)

Once I save the configuration I get a 500 error.
The website encountered an error while retrieving www.bpm.com/administrator/index.php?option=com_cbjuice2&task=save&view=default . It may be down for maintenance or configured incorrectly.

I just migrated my site to a new host. What could I have missed?

Please Log in to join the conversation.

7 years 6 months ago #220063 by jciconsult
Replied by jciconsult on topic Getting error on Save
Immediate suggestion is to check the consistency of your database using various tests such as the Tools in CB. Is there a possibility that your prefix got changed during your migration?

Please Log in to join the conversation.

7 years 6 months ago #220064 by wolverton
Replied by wolverton on topic Getting error on Save
Looking at the code, it would appear that for some reason field names are not being picked up in the code at line 87 of save.php:

$full_field_names=$_CB_database->getTableFields(array('#__users','#__comprofiler'),TRUE);


The only other way it could happen is if you entered all the users and comprofiler fields into the "Fields excluded from Save" box.

Please Log in to join the conversation.

7 years 6 months ago #220065 by jase700
Replied by jase700 on topic Getting error on Save

jciconsult wrote: Immediate suggestion is to check the consistency of your database using various tests such as the Tools in CB. Is there a possibility that your prefix got changed during your migration?


Nothing wrong in the consistency checks...

Please Log in to join the conversation.

7 years 6 months ago #220067 by jase700
Replied by jase700 on topic Getting error on Save
Will this work with "mysqli"

Please Log in to join the conversation.

7 years 6 months ago #220068 by wolverton
Replied by wolverton on topic Getting error on Save
It'll work with either Mysql or Mysqli.
Try turning on error reporting and see if you get any error messages.

Please Log in to join the conversation.

Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.457 seconds

Facebook Twitter LinkedIn