Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Seriously Lost... (1046)


Guest

Recommended Posts

Okay so I first:

 

1. Upload Files

2. Run installer

3. While on DB install page, I made the DB and User

4. Complete install

5. 1046 - No database selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

So ummm I am pretty stuck now... I have checked the configure files and they are just fine!

 

Please someone help me! I would really appreciate it

Link to comment
Share on other sites

Ok so now in my /admin page I get this message:

 

Fatal error: Cannot re-assign $this in /home3/mediafum/public_html/rs-currency.net/admin/includes/classes/upload.php on line 31

 

On line 31 of this file, I have

 

$this = null;

 

Any ideas?

Link to comment
Share on other sites

ok you prob have MS1/2 as this look like a monster template template?

 

try reuploading :

 

admin/includes/classes/upload.php

 

and hope that sorts it

Link to comment
Share on other sites

For some reason it was not in there. I put it in there, and its still giving problem =/

 

Please keep helping. I feel like we are getting closer

Link to comment
Share on other sites

ok you need to replace this line 31:

 

from this :

 

$this = null;

 

to this :

 

// $this = null;

 

as your server/host is using PHP5 and this v (MS2) of osC is not good with PHP5 if you get a lot of error in the shop (which you may) you will need to upgrade the V of the shop

Link to comment
Share on other sites

1)cPanel or the like and chom to 0644

 

2) DELETE your Installation directory

 

3) get your host to put a p/word on your admin directory for you A.S.A.P DO THIS ONE FIRST AS A MUST!!!!!!!!!!!!

Link to comment
Share on other sites

Found another error =/

 

http://www.rs-currency.net/index.php?cPath=25

 

That is everything on the toolbar that goes to that (right side)

 

Gives error: 1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '25'

Link to comment
Share on other sites

not looking good !!!!

 

SORRY BUT!!!!!!!!!!!!!!!!!

you have one of 2 things to do

 

1) see if your host will give you PHP4?

or

2) you will need to upgrade the osC to the latest v RC2.2a but you may need to get someone to do this as it will take about 1 to 2 day work with the template you have (I now this as I have done it about 12 time for clients now)

 

3) see if you can swope the template you have for one that will work with a osC RC1 or 2

Link to comment
Share on other sites

Found another error =/

 

http://www.rs-currency.net/index.php?cPath=25

 

That is everything on the toolbar that goes to that (right side)

 

Gives error: 1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '25'

 

 

ok so I'we looked in this forum and got this line that should be replaced in the index.php or products.php file

 

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "'";

 

with the following:

 

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

 

 

it worked with removing the error code this HOWEVER led to another problem that it displays (when you press on a category) you get this message

 

"There are no products to list.... "

 

Even if I can clearly see that there is products in categories...

 

I'we also have the osCommerce 2.2-MS2

 

but yeah... is there really no way to go from here ?? found this template I'we really much would like to use BUT not spend 2 days and what should be changed? :blink:

Link to comment
Share on other sites

ok so I'we looked in this forum and got this line that should be replaced in the index.php or products.php file

 

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "'";

 

with the following:

 

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

 

 

it worked with removing the error code this HOWEVER led to another problem that it displays (when you press on a category) you get this message

 

"There are no products to list.... "

 

Even if I can clearly see that there is products in categories...

 

I'we also have the osCommerce 2.2-MS2

 

but yeah... is there really no way to go from here ?? found this template I'we really much would like to use BUT not spend 2 days and what should be changed? :blink:

 

 

what is your

 

PHP version:

MySQL version:

are you using a Template Monster template?

also give a url

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...