Jump to content

CC3 Mysql Error


Guest manmademan123

Recommended Posts

Guest manmademan123

I have tried to install CC3 both ways.

With Manual Method as soon as I go to url:

http://www.uksoundlabs.net/store/admin/

i get a 404 error on index.php, it cant find it, but it is there. Also the url changes to:

http://www.uksoundlabs.net/admin/index.php?

When I do Auto Method install i get:

MySQL Error Occured

1050: Table 'CubeCart_Downloads' already exists

QUERY = CREATE TABLE `CubeCart_Downloads` ( `id` int(11) NOT NULL auto_increment, `customerId` int(11) NOT NULL default '0', `cart_order_id` varchar(32) NOT NULL default '', `noDownloads` int(11) NOT NULL default '0', `expire` int(11) NOT NULL default '0', `productId` int(11) NOT NULL default '0', `accessKey` varchar(10) NOT NULL default '', KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1;f

I have started fresh, no pre installed versions of cubecart. Linux server. Globals on.

any ideas?

cheers

Link to comment
Share on other sites

Guest Feldon

I've just tried to install (Auto Method) CC3

And after step 4 I reseived this message.

MySQL Error Occured

1060: Duplicate column name 'cat_id'



QUERY = CREATE TABLE `CubeCart_category` ( `cat_name` text NOT NULL, `cat_id` int(16) NOT NULL auto_increment, `cat_father_id` int(16) NOT NULL default '0', `cat_image` varchar(250) NOT NULL default '', `per_ship` decimal(20,2) NOT NULL default '0.00', `item_ship` decimal(20,2) NOT NULL default '0.00', `item_int_ship` decimal(20,2) NOT NULL default '0.00', `per_int_ship` decimal(20,2) NOT NULL default '0.00', `noProducts` int(11) default '0', PRIMARY KEY (`cat_id`,`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=32;






This comes when I try to load the store page:


MySQL Error Occured

1146: Table 'feldon_store.CubeCart_sessions' doesn't exist



QUERY = INSERT INTO CubeCart_sessions (`location`, `sessId`, `timeStart`, `timeLast`, `customer_id`) VALUES ('/store/index.php?', 'fb519e94353609cf5ca63fa63af1f5c2', '1112376337', '1112376337', 0)






And this when I'm in Admin panel


MySQL Error Occured

1146: Table 'feldon_store.CubeCart_inventory' doesn't exist



QUERY = SELECT count(productId) as noProducts FROM CubeCart_inventory

I went through it 3 time all over (clean all DB users... every time I've got the same problems)

What's wrong.

Link to comment
Share on other sites

Guest billmc

Hi feldon,

Dump the database and edit in the SQL file the duplicat reference to

'cat_id'




 Change 


PRIMARY KEY (`cat_id`,`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=32;
 



to 


PRIMARY KEY (`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=32;

your other errors are dependent on the database not having been installed correctly

hth

billmc

:wacko:

Link to comment
Share on other sites

Guest Feldon

OK. Im' 1 step further

Before I had 6 entrys in my DB.

:wacko:

 CubeCart_Downloads

  CubeCart_Modules

  CubeCart_admin_permissions

  CubeCart_admin_sections

  CubeCart_admin_sessions

  CubeCart_admin_users




Now there's 8  
CubeCart_Downloads

  CubeCart_Modules

  CubeCart_admin_permissions

  CubeCart_admin_sections

  CubeCart_admin_sessions

  CubeCart_admin_users

  CubeCart_category

  CubeCart_cats_idx






And again ERROR :


Server: localhost   Database: feldon_store  

Error 

SQL-query: 



-- --------------------------------------------------------

-- 

-- Table structure for table `CubeCart_countries`

-- 

CREATE TABLE `CubeCart_countries` (



`country` text NOT NULL ,

`country_id` int( 16 ) NOT NULL default '0',

`status` char( 1 ) NOT NULL default 'i',

PRIMARY KEY ( `country_id` , `country_id` ) 

) TYPE = MYISAM 

MySQL said:  



#1060 - Duplicate column name 'country_id' 

 

[ Back ]  

Why with me DUPLICATE names ?

I'm using the same db.sql as everybody I THINK :P

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...