Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Database Error 1046 Rate Topic   - - - - -

 

Posted 22 June 2007 - 03:48 AM #1

Hi,

Need some help please. I'm getting the following error on install.
Database error: 1046 : No database selected
Invalid query: SHOW TABLES LIKE 'cscart_%'


--------------------------------------------------------------------------------
Database Error: 1046 : No database Selected
Invalid Query: SHOW TABLES LIKE 'cscart_%'

Backtrace: File: /home/xqu14481/public_html/xc-store/install.php
Line: 41
Function: include
File: /home/xqu14481/public_html/xc-store/core/install.php
Line: 87
Function: db_get_array
File: /home/xqu14481/public_html/xc-store/core/fn_database.php
Line: 42
Function: db_query
File: /home/xqu14481/public_html/xc-store/core/db_mysql.php
Line: 89
Function: db_debug_error

Any help appreciated! Couldnt find any info on previous posts. Thanks!

 

Posted 22 June 2007 - 04:08 AM #2

The sample database that you're attempting to install in corrupt.
Re-upload the /var/database folder and try again.
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 

Posted 22 June 2007 - 04:46 AM #3

Tried re-uploading it, getting the same error.
I'm not installing demo catalogue either (does that make a difference?)

Could it be any of the permissions that i had to change?

config.php - read/write for all (chmod 666 config.php)
[cscart_directory]/skins - read/write/execute for all (chmod 777 .)
[cscart_directory]/images - read/write for all (chmod -R 777 ./images)
[cscart_directory]/var - read/write for all (chmod -R 777 ./var)
where [cscart_directory] - directory on the server where CS-Cart package was unpacked.

what is -R 777? as opposed to just 777?

 

Posted 22 June 2007 - 04:57 AM #4

-Recursive

Make sure that the /var/database and assocaited files are set to 777
otherwise cs-cart can't access it. I've seen people work around this however it's just plain easier :D
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 

Posted 22 June 2007 - 05:04 AM #5

Ok, done, had one error

550 Prohibited file name: .pureftpd-upload.4678f178.15.4cbd.50430aae
(using smartFTP)

and still getting the same error

Thanks for your help btw!

 

Posted 22 June 2007 - 05:16 AM #6

You will have to delete that file from your webhosting file manager.
That file itself will stop your store from working successfully in most cases

It's a pain in the arse to use internet explorer to upload files, so I suggest you use an application like Flashfxp or SmartFTP (I use flash)
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 

Posted 22 June 2007 - 07:12 AM #7

well i re-uploaded everything. took almost an hour. it's kind of working now. but have a new problem

http://apollo.webcit...php?target=cart

all the warnings. Any suggestions? thanks!

 

Posted 22 June 2007 - 08:02 AM #8

No issue from me.
Works fine as far as I can see
I've moved on from CS-Cart to WooC******** - If you need anything I can be of little help.

 

Posted 22 June 2007 - 04:22 PM #9

yeah, i must've fixed it before you got to it. Hopefully everything will run as planned (found some files that didnt upload, not sure if its a SmartFTP problem).
Thanks for all your help!