Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

SQL Error after upgrading from CB 1.3.1 to 1.4

13 years 5 months ago #168880 by natecovington
SQL Error after upgrading from CB 1.3.1 to 1.4 was created by natecovington
Hi,

I am having trouble with upgrading to CB 1.4 on a Joomla 1.5.23 site. When I install the latest version, and try to edit a user's profile through /administrator, it gives me this error message after saving:

=========================================

moscomprofiler::store failed: Unknown column 'lname' in 'field list' SQL=UPDATE `jos_comprofiler` SET `user_id`=41603,`firstname`='Test',`lastname`='User',`hits`='0',`message_last_sent`='0000-00-00 00:00:00',`message_number_sent`='0',`avatarapproved`='1',`approved`=1,`confirmed`=1,`registeripaddr`='',`cbactivation`='',`banned`='0',`acceptedterms`='0',`lname`='',`state`='',`country`='',`lastupdatedate`='0000-00-00 00:00:00',`cb_newsletters`=0,`cb_state`='test',`cb_country`='test' WHERE id='4603'

=========================================

I've tried running through the Components -> CB -> Tools and all come back fine / green.

I found a similar thread but it was closed:
www.joomlapolis.com/forum/43-bugs/89385-moscomprofiler-store-failed-unknown-column

Am I looking at the same issue here? I did not build this site and it came to me with many 3rd party plugins so I'm not sure if one of them would have added a column to the table.

I am able to edit / save users through the core Joomla user manager, but not with CB.

It looks like "lastname" is a valid column in the CB tables, but not "lname" - any suggestions? If possible, can you provide an SQL query that would properly add this column and trick CB into saving the user?

Also, I do not have the CB User Gallery plugin installed.

Thanks in advance,
-Nate

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48622
  • Thanks: 8302
  • Karma: 1446
13 years 5 months ago #168923 by krileon
Typically this is due a 3rd party integration. Please disable non-core CB fields 1 by 1 until the issue resolves. Also when an error occurs please enable debug mode and maximum error reporting within Joomla global configuration then duplicate the error. This will give you a "callstack" directly below the query pointing out exactly what file the error happened at.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

13 years 5 months ago - 13 years 5 months ago #168955 by natecovington
Replied by natecovington on topic Re: SQL Error after upgrading from CB 1.3.1 to 1.4
Hi,

Thanks for your response. When I go into CB Fields area, I don't see any "non-core" fields in here (see screenshot)

I also changed "error reporting" to "maximum" and no other errors came up below the SQL error message.

Please advise?

Thanks,
-Nate

Screenshot:
www.arabianhorseglobal.com/nate/sql.png
Last edit: 13 years 5 months ago by natecovington. Reason: screenshot attachment wouldn't work

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

13 years 5 months ago #169613 by natecovington
Replied by natecovington on topic Re: SQL Error after upgrading from CB 1.3.1 to 1.4
Hi,

I have reverted back to CB 1.3.1 and we are also not able to save profile data from either the backend or the frontend. I enabled error reporting / debug and below is what it gives us when saving through the frontend. When you go back in to edit the profile again, any changes are NOT stored. Same with editing from the backend, it doesn't save any field data.

Also I have 3 PDF's containing a list of the modules / plugins / components we have installed:

www.arabianhorseglobal.com/nate/AHG-modules.pdf
www.arabianhorseglobal.com/nate/AHG-plugins.pdf
www.arabianhorseglobal.com/nate/AHG-components.pdf

Maybe one of these extensions is causing issues? Let me know if I can do anything else to help diagnose...

Thanks,
-Nate



Profile Information
Application afterLoad: 0.000 seconds, 0.10 MB
Application afterInitialise: 0.016 seconds, 0.62 MB
Application afterRoute: 0.024 seconds, 0.86 MB
Application afterDispatch: 0.049 seconds, 2.50 MB
Application afterRender: 0.128 seconds, 2.95 MB
Memory Usage
3142988
20 queries logged

SELECT *
FROM jos_session
WHERE session_id = 'a1164f55861f679a70e201bdb4797c95'
DELETE
FROM jos_session
WHERE ( TIME < '1310579157' )
SELECT *
FROM jos_session
WHERE session_id = 'a1164f55861f679a70e201bdb4797c95'
UPDATE `jos_session`
SET `time`='1310580957',`userid`='4603',`usertype`='Super Administrator',`username`='nate',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1310580339;s:18:\"session.timer.last\";i:1310580946;s:17:\"session.timer.now\";i:1310580957;s:22:\"session.client.browser\";s:83:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:5.0.1) Gecko/20100101 Firefox/5.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:4:\"4603\";s:4:\"name\";s:14:\"Nate Covington\";s:8:\"username\";s:4:\"nate\";s:5:\"email\";s:27:\"nate@covingtoncreations.com\";s:8:\"password\";s:65:\"be97b38d185a763cfe4c2146614d6b7d:ihwFkSNTa8QvgsPcSAan5CpMlElKlE8Q\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2011-06-20 17:56:22\";s:13:\"lastvisitDate\";s:19:\"2011-07-13 18:06:42\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:57:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=-5\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:69:\"/Applications/MAMP/htdocs/ahg/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":5:{s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:2:\"-5\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:17:\"application.queue\";a:1:{i:0;a:2:{s:7:\"message\";s:30:\"Your settings have been saved.\";s:4:\"type\";s:7:\"message\";}}}referrerid|s:10:\"AUPRR-NATE\";'
WHERE session_id='a1164f55861f679a70e201bdb4797c95'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 23)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 4603
SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name

FROM jos_comprofiler_plugin

WHERE published = 1
AND access <= 2
AND TYPE = 'user'

ORDER BY ordering
SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name

FROM jos_comprofiler_plugin

WHERE published = 1
AND access <= 2
AND TYPE = 'templates'

ORDER BY ordering
SELECT `gid`

FROM `jos_users`

WHERE `id` = 4603
SELECT g1.`id` AS group_id, g1.`name`

FROM `jos_core_acl_aro_groups` AS g1

LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` <= g1.`lft`

WHERE g2.`id` = 25

ORDER BY g1.`name`
SELECT g1.`id` AS group_id, g1.`name`

FROM `jos_core_acl_aro_groups` AS g1

LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` >= g1.`lft`

WHERE g2.`id` = 25

ORDER BY g1.`name`
SELECT *
FROM jos_comprofiler_tabs t

WHERE t.enabled=1

AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)

ORDER BY t.POSITION, t.ordering
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
SELECT f.*
FROM jos_comprofiler_fields f

INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)

WHERE f.published = 1
AND f.profile != 0
AND t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)

ORDER BY t.POSITION, t.ordering, f.ordering
SELECT MAX(TIME)
FROM jos_session
WHERE userid = 4603
AND guest = 0
SELECT m.*, am.params AS adv_params
FROM jos_modules AS m
LEFT JOIN jos_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
ORDER BY m.ordering, m.id
SELECT parent
FROM jos_menu
WHERE id = 23
LIMIT 1

Language Files Loaded

/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.ini 1
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.plg_system_debug.ini 1
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.com_alphauserpoints.ini 1
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.com_comprofiler.ini
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.com_user.ini 1
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.com_k2.ini 1
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.tpl_beez.ini 1
/Applications/MAMP/htdocs/ahg/language/en-GB/en-GB.mod_mainmenu.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

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

Moderators: beatnantkrileon
Powered by Kunena Forum