Skip to Content Skip to Menu

Error: 1064 HAPPENED AFTER INSTALLED CB 2.0. It does this from our home page...

10 years 1 month ago #250436 by GODpleasers
1064

Error: 1064

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 jos_comprofiler WHERE user_id = '424' LIMIT 1' at line 1 SQL=SELECT FROM jos_comprofiler WHERE user_id = '424' LIMIT 1

Come worship Jesus with us..
GOD Speaks internet radio- :-) - GOOD :-) - Music that employs life, deliverance, & restoration - COMPLETE :-)
godspeaksinternetradio.com/

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 1 month ago #250450 by nant

GODpleasers wrote: 1064

Error: 1064

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 jos_comprofiler WHERE user_id = '424' LIMIT 1' at line 1 SQL=SELECT FROM jos_comprofiler WHERE user_id = '424' LIMIT 1


Was this a clean CB 2.0 install or an upgrade from a previous CB version?
If it was an upgrade, from what CB version?
Joomla version?

Run all relevant CB Tools and check is anything is reported.

Enable Joomla debug at maximum level and see if more information is displayed - is this the complete message you see or is there more?

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

10 years 1 month ago - 10 years 1 month ago #250500 by GODpleasers

nant wrote:

GODpleasers wrote: 1064

Error: 1064

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 jos_comprofiler WHERE user_id = '424' LIMIT 1' at line 1 SQL=SELECT FROM jos_comprofiler WHERE user_id = '424' LIMIT 1


Was this a clean CB 2.0 install or an upgrade from a previous CB version?
If it was an upgrade, from what CB version?
Joomla version?

Run all relevant CB Tools and check is anything is reported.

Enable Joomla debug at maximum level and see if more information is displayed - is this the complete message you see or is there more?





It was a upgrade. Joomla 2.5 and CB version is : 1.9.1 We have uninstalled it since then. Any how it worked kind of except the profiles looked nothing like pictured on the site for it ). what happened was it worked till we logged out than it gave that error message when we went back to godspeaksinternetradio.com/ . What would happen if we uninstalled the previous version first?



If we make you an administrator can you install this for us?

Come worship Jesus with us..
GOD Speaks internet radio- :-) - GOOD :-) - Music that employs life, deliverance, & restoration - COMPLETE :-)
godspeaksinternetradio.com/
Last edit: 10 years 1 month ago by GODpleasers.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 1 month ago - 10 years 1 month ago #250505 by nant

GODpleasers wrote:

nant wrote:

GODpleasers wrote: 1064

Error: 1064

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 jos_comprofiler WHERE user_id = '424' LIMIT 1' at line 1 SQL=SELECT FROM jos_comprofiler WHERE user_id = '424' LIMIT 1


Was this a clean CB 2.0 install or an upgrade from a previous CB version?
If it was an upgrade, from what CB version?
Joomla version?

Run all relevant CB Tools and check is anything is reported.

Enable Joomla debug at maximum level and see if more information is displayed - is this the complete message you see or is there more?





It was a upgrade. Joomla 2.5 and CB version is : 1.9.1 We have uninstalled it since then. Any how it worked kind of except the profiles looked nothing like pictured on the site for it ). what happened was it worked till we logged out than it gave that error message when we went back to godspeaksinternetradio.com/ . What would happen if we uninstalled the previous version first?



If we make you an administrator can you install this for us?


Please list which CB Plugins you have on your CB 1.9.1 site.

When you upgrade from CB 1.9.1 to CB 2.0, if you want the new profile layout (kije the pictures) you need to run the Canvas tool on your CB Tools area.
Last edit: 10 years 1 month ago by nant.

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

10 years 1 month ago #250508 by GODpleasers

nant wrote:

GODpleasers wrote:

nant wrote:

GODpleasers wrote: 1064

Error: 1064

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 jos_comprofiler WHERE user_id = '424' LIMIT 1' at line 1 SQL=SELECT FROM jos_comprofiler WHERE user_id = '424' LIMIT 1


Was this a clean CB 2.0 install or an upgrade from a previous CB version?
If it was an upgrade, from what CB version?
Joomla version?

Run all relevant CB Tools and check is anything is reported.

Enable Joomla debug at maximum level and see if more information is displayed - is this the complete message you see or is there more?





It was a upgrade. Joomla 2.5 and CB version is : 1.9.1 We have uninstalled it since then. Any how it worked kind of except the profiles looked nothing like pictured on the site for it ). what happened was it worked till we logged out than it gave that error message when we went back to godspeaksinternetradio.com/ . What would happen if we uninstalled the previous version first?



If we make you an administrator can you install this for us?


Please list which CB Plugins you have on your CB 1.9.1 site.

When you upgrade from CB 1.9.1 to CB 2.0, if you want the new profile layout (kije the pictures) you need to run the Canvas tool on your CB Tools area.



What is a canvas tool and where do we get it? Our plugins are

Default language (English) Installed Published Public language default_language
2 Default Installed Published Move Down Public templates default
3 WinClassic Installed Published Move Up Move Down Public templates winclassic
4 WebFX Installed Published Move Up Move Down Public templates webfx
5 OSX Installed Published Move Up Move Down Public templates osx
6 Luna Installed Published Move Up Move Down Public templates luna
7 Dark Installed Published Move Up Public templates dark
8 CB reCAPTCHA Installed Unpublished Move Down Public user cb.recaptcha
9 Private Message System Installed Published Move Up Move Down Public user pms.mypmspro
10 Content Author Installed Published Move Up Move Down Public user cb.authortab
11 CB Core Installed Published Move Up Move Down Public user cb.core
12 CB Menu Installed Published Move Up Move Down Public user cb.menu
13 CB Connections Installed Published Move Up Move Down Public user cb.connections
14 Forum integration Installed Unpublished Move Up Move Down Public user cb.simpleboardtab
15 Mamblog Blog Installed Unpublished Move Up Move Down Public user cb.mamblogtab
16 YaNC Newsletters Installed Unpublished Move Up Move Down Public user yanc
17 jNews CB Plugin Installed Unpublished Move Up Public user jnews_cb

Come worship Jesus with us..
GOD Speaks internet radio- :-) - GOOD :-) - Music that employs life, deliverance, & restoration - COMPLETE :-)
godspeaksinternetradio.com/

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 1 month ago #250509 by nant
Ok #8 and #17 are the only third-party plugins that you have so keeping them unpublished is ok until they have new releases.

Once you install CB 2.0 you will see the new Canvas Tool button on your CB Tools area.

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

Moderators: beatnantkrileon
Powered by Kunena Forum