Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Updating to v2.2


DailyLunatic

Recommended Posts

When attempting to update to v2.2 I get the following errors.

 

Any ideas what it is trying to tell me.

 

Thanks,

Sterling

92.5% Pure

 

*****

Status: Update Complete!

 

 

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/username/mydomain.com/catalog/install/includes/functions/database.php on line 45

 

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/username/mydomain.com/catalog/install/includes/functions/database.php on line 45

 

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/username/mydomain.com/catalog/install/includes/functions/database.php on line 45

 

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/username/mydomain.com/catalog/install/includes/functions/database.php on line 45

 

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/username/mydomain.com/catalog/install/includes/functions/database.php on line 45

 

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/username/mydomain.com/catalog/install/includes/functions/database.php on line 45

 

The database upgrade procedure was successful!

*****

Sterling (a.k.a. DailyLunatic)

Useful Threads: Basics for Design.

Useful URL's: Knowledge Base, SQL Tutorial,

My Setup: Master Products v1.2, Need help installing Bundled Products v1.4.

Link to comment
Share on other sites

  • 1 month later...
  • 1 year later...

I am getting the same errors. I have echod out the SQL queries that are causing the errors. If I try pasting the queries into phpMyAdmin, they all come back with an error saying that either a table, or field does not exist.

 

 

The sql queries are:

 

select address_book_id, customers_id from address_book_to_customers

 

select customers_id, customers_gender, customers_firstname, customers_lastname, customers_street_address, customers_suburb, customers_postcode, customers_city, customers_state, customers_country_id, customers_zone_id from customers

 

select categories_id, categories_name from categories order by categories_id

 

select orders_id, shipping_method, shipping_cost, currency, currency_value from orders

 

select products_id, products_name, products_description, products_url, products_viewed from products order by products_id

 

select r.reviews_id, re.products_id, re.customers_id, r.reviews_rating, re.date_added, re.reviews_read, r.reviews_text from reviews r, reviews_extra re where r.reviews_id = re.reviews_id order by r.reviews_id

 

Any ideas anyone.

 

Thanks in advance.

 

Andrew.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...