[elite]

Guys,

I've opened ticket 24930, any news on this?

Has there been any MySQL or PHP changes since last night as that's when the problems started happening?

Cheers

Alex

[Kieran]

If you are seeing an error when you try to access MySQL enabled sites, can you please post this error up. If not can you please better describe your problem.

[elite]

Originally Posted by Kieran

If you are seeing an error when you try to access MySQL enabled sites, can you please post this error up. If not can you please better describe your problem.

The error I get is:

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 = '24'

<SMALL>[TEP STOP]</SMALL>
<SMALL></SMALL>
<SMALL>You can see an example of it here:</SMALL>
<SMALL></SMALL>
<SMALL>http://www.elitecarcare.co.uk/index.php?cPath=24&osCsid=c189a7f29858538df9a9ed93 cf38e112</SMALL>
<SMALL></SMALL>
<SMALL>I get this error when trying to view products, categories and manufacturers on my site.</SMALL>
<SMALL></SMALL>
<SMALL>It started last night.</SMALL>
<SMALL></SMALL>
<SMALL>I'm also seeing an error when logging into the Control panel, my total disk quota is missing and shaded red??</SMALL>
<SMALL></SMALL>
<SMALL>Has there been any changes or updates on the Golf server in the last 24 hours?</SMALL>

[Kieran]

Is there a column products_id in the table products? If there is, the table may have errors with it. You should try doing a repair on that table:-

REPAIR TABLE products;

At the SQL prompt or using phpmyadmin.

I can't comment on the problems in the cpanel or potential server changes other than the fact that server changes that are scheduled are always announced so if you didn't receieve anything by e-mail its fairly safe to assume there have been no server changes.

[elite]

I have been advised by a friend who has kindly looked at this for me that Xilo have upgraded to SQL5.

Is this correct?

I STILL haven't had a reply to my ticket!

[Matt]

Alex,

As I have replied in your ticket. I just wanted to resolve it here to. However, please do not duplicate issues in both the forum and helpdesk.

The issue appears to be related to an upgrade that Psoft (creators of H-Sphere) conducted without asking our prior permission. This was to fix the disk quota issue that the control was displaying.

They continued with the upgrade which inturn, upgraded all shared servers to MySQL 5. Whilst this will not affect the majority of customer - it may affect some older scripts or ones that have been written for MySQL 4.

I have found the following URL for you Alex that should resolve the issue and if you require further help - please let us know.

osCommerce 2.2 Milestone 2 Update 051112

We have demanded that in future any upgrades that are required must be detailed and permission granted before being completed.

I must also stress that generally - upgrades are completed by our staff, in house - however, due to a technical problem with H-Sphere, Psoft staff had to assist due to a development issue.

Thank you

Matt

[elite]

Thanks for the info Matt.

I'm working on the fix at the moment.

Just a suggestion, but it might be sending a quick "work in progress" reply when a ticket is logged, that way the customer knows you're on the case.

Regards

Alex

[Tom]

I'll make sure Matt is notified of this post. He is in RedBus today.

Tom

[Skatiechik]

Also another database related enquiry.

I can't access the database via phpmyadmin through the control panel. It just says:

Not Found
The requested URL /phpMyAdmin/index.php was not found on this server.

Also a numpty question from someone who is still learning:

If the server was upgraded to MYSQL5, will this effect those of us who are running php forums (phpBB for me) and specified the database was MYSQL4? I presume not as it seems to be running fine

[Tom]

It seems that the latest update of H-Sphere has knocked out PMA - We are getting this sorted now - apologies.

If your forum is working there is no need to worry. It only affected one customer which was unfortunate but Psoft did not tell us they were going to upgrade MySQL before hand.

Tom