Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 07-21-2009 13:50:40

thomking
Member
Registered: 03-31-2004
Posts: 44

Joomla Activation

Hi there... I have installed all the scripts and activated everything... on a staging area at http://www.steviva.com/1.5/. But, every time I actually enable any of the CCP7 mods I get a blank page at http://www.steviva.com/1.5/.

Any suggestions

Offline

 

#2 07-21-2009 14:06:24

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

You've installed Joomla! at:

http://www.steviva.com/1.5/

What you're saying is that you've installed the CCP Joomla! extensions and enabled all of them and when you hit that URL everything comes up blank.

Is this right?  Are you sure you not only enabled the component and modules - but you enabled the plugins too?


Nick Hendler

Offline

 

#3 07-21-2009 16:29:51

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

Yes... everything was installed and activated and the site came up as a blank page. I stepped away from my computer for a while and came back and Joomla logged me out. When I logged back in the and now the Joomla Control Panel page comes up blank and the admin control panel is gone. Just a blank page. Any ideas on this?

Offline

 

#4 07-21-2009 16:32:02

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

I can't login to the Joomla cpanel at all...

Offline

 

#5 07-22-2009 07:46:43

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

A blank page indicates a PHP error.  We know there are no PHP errors in the CCP modules, plugins and component for Joomla! and they work when they're activated so there may be an issue with your Joomla! install.  Hitting your frontpage there are no errors, but hitting the CCP component page:

http://www.steviva.com/1.5/index.php?op … ickcartpro

We get the blank screen.  This means that something isn't playing nice on the Joomla! side when the CCP extensions are activated.  Are you sure you activated all of them - including the system plugin???


Nick Hendler

Offline

 

#6 07-22-2009 08:17:23

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

So... what now? It seems odd to me that the user pages are showing up fine but, admin is coming up blank. And the rub is that I can not bring up the Joomla Admin to make sure all the CCP extensions are activated. Any suggestions?

Offline

 

#7 07-22-2009 09:47:17

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

Try this.  This basically lets you connect to your Joomla! database from your ClickCartPro management interface and activate all of the modules, plugins, etc.

(1) Login to your CCP management interface.

(2) Access 'System > Database > Alternate Connections' and choose the 'New Connection' option. 

(3) On the following page, select the database type you're using for your Joomla! install.  Submit your selection.

(4) On the following page, enter the connection information for the the database type you're using for your Joomla! install.  Submit your selection.

(5) Next, access 'System > Database > Raw Database Admin' and choose the 'Change Active Connection' option.

(6) On the following page, select the connection to the Joomla! database you created.

(7) On the following page, you will be looking at your Joomla! database.  Select the 'SQL Statement' option.

(8) On the following page, enter the following three SQL statements (individually - one at a time) and submit them:

UPDATE jos_plugins SET published=1 WHERE name LIKE '%ClickCartPro%'

UPDATE jos_components SET enabled=1 WHERE name='ClickCartPro Connector'

UPDATE jos_modules SET published=1 WHERE module LIKE '%clickcartprowidget%'

(9) Return to 'System > Database > Raw Database Admin' and choose the 'Change Active Connection' option.

(10) On the following page, select the 'Primary Connection' option.


Nick Hendler

Offline

 

#8 07-22-2009 22:32:58

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

Nope... I got this message:

Script Execution Error

There was a processing problem encountered while processing your request. Please try again later.
File: /core/CORE/CORE.php Line: 510 Error Number: 256

Offline

 

#9 07-23-2009 06:59:35

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

Doing what?  What step did you get the error on?


Nick Hendler

Offline

 

#10 07-23-2009 09:58:00

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

(4) On the following page, enter the connection information for the the database type you're using for your Joomla! install.  Submit your selection.

Offline

 

#11 07-23-2009 10:48:40

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

Not sure why that's producing an error.  Make sure your connection settings are correct.  If they are, your server may not be set up for concurrent connections and you'll need to use a tool like PHPMyAdmin to accomplish the same thing.


Nick Hendler

Offline

 

#12 07-23-2009 18:57:26

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

I have PHPMyAdmin... how would I utilize this? Thanks!

Offline

 

#13 07-23-2009 19:06:22

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

Look at the manual for it.


Nick Hendler

Offline

 

#14 07-23-2009 19:16:41

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

Nice.... I meant to activate the CCP7 modules.

Offline

 

#15 07-24-2009 07:07:18

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

I seriously thought you meant 'how do you use PHPMyAdmin'.  To activate the modules, submit these statements:

UPDATE jos_plugins SET published=1 WHERE name LIKE '%ClickCartPro%'

UPDATE jos_components SET enabled=1 WHERE name='ClickCartPro Connector'

UPDATE jos_modules SET published=1 WHERE module LIKE '%clickcartprowidget%'


Nick Hendler

Offline

 

#16 07-24-2009 09:49:08

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

smile I know... Hey... I get tons of meticulous tech questions thrown my way as well. Hopefully I wasn't the butt of stupid tech support water cooler talk. Thanks!

Offline

 

#17 07-24-2009 16:32:42

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

OK... I went in through MvPHPAmdin and

The admin is coming up again... yeah. The page comes up but is not displaying any of the CCP7 Mods.

And when I try to create a new database connection I am still getting the following error:

Script Execution Error

There was a processing problem encountered while processing your request. Please try again later.
File: /core/CORE/CORE.php Line: 510 Error Number: 256

Any suggestion?

Offline

 

#18 07-24-2009 16:40:13

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

I am not sure this is of any consiquence but in trying to access aw Database Admin in table jos_commponents

System: Raw Database Admin

All Raw Database Admin functions are unguided. Deletion of and changes to system data, tables and table columns can result in making this software inoperable. Be careful.

A problem was encountered while executing the SQL statement submitted. The error was reported as: The MySQL extension encountered a problem submitting an SQL statement. MySQL reported the error as: 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 'option, ordering, admin_menu_img, iscore, params, enabled FROM jos_components OR' at line 1

The following SQL statement was submitted: SELECT id, name, link, menuid, parent, admin_menu_link, admin_menu_alt, option, ordering, admin_menu_img, iscore, params, enabled FROM jos_components ORDER BY id ASC

Offline

 

#19 07-24-2009 16:41:34

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: Joomla Activation

Are you opening admin with the Web2 display? If so try the standard display.

Also check your core_formfields database for a field that maybe doesn't have an entry in it's name field or data that looks out of place, I have had that error and no display on a field entry I did that the name was not populated, causeing the error.

John

Offline

 

#20 07-24-2009 16:48:35

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

I have been using the standard interface... and I didn't see anything in the core_formfields  that looked out of place

Offline

 

#21 07-27-2009 10:47:53

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19798
Website

Re: Joomla Activation

That error is because of how the jos_components table is built by Joomla!.  It uses the column name 'ordering' which is not ANSI-standard.  CCP fails on doing a browse of that table.   That's OK - you can still execute raw SQL statements against it.


Nick Hendler

Offline

 

#22 07-27-2009 11:26:27

thomking
Member
Registered: 03-31-2004
Posts: 44

Re: Joomla Activation

I am not sure what you mean by raw SQL statements against it. I assume that it has made the connection between CCP7 and Joomla however, even though I have all of the mods activated and positioned properly within the template they are not showing up on the Joomla site. So... here's the CCP7 site http://www.steviva.com/ccp7/ and here's the Joomla site http://www.steviva.com/1.5/ and no modules appear. Thanks Nick.

Offline

 

Board footer