Help! Please! Database corrupt!!!!!!!!

[Guest]

Hi all,

 

Since my webhosting company decided to move my website I have had major problems with the website.

 

I can get my site up, but now if a person places and order I am not able to see it. I recieve an email notificiation, but am unable to see the order. My customers are getting upset by this. Can someone help? Please?

[mattice]

so is the order actually present in the database?

(not through the admin, but with phpMyAdmin for instance)

 

(table "orders" by default)

 

Mattice

[Guest]

Yes its strange actually - the order is in the database but is not visible to myself or the customers.

 

i.e. When I recieve the order process email I have the order number in it. When I go to my admin/default.php page I cannot see it, but once I click on orders and put in the order number on the search field I can see it.

 

Unfortunately my customers cannot see it - which causes problems for both parties.

 

Can anyone help?

[zzfritz]

once I click on orders and put in the order number on the search field I can see it

So, your database is not "corrupt" after all. And if the order is displayed in admin, the configure.php defines for the database must be working. Are you saying the order is individually displayed when requested by Order ID, but no orders at all are displayed when selected by Status?

 

And on the catalog side, are you saying orders are being taken but the account order history displays nothing? Are any other account pages not displaying their data (account info, address book)?

 

For the best assistance, give precise details of what is observed.

[Guest]

I had my website moved from one server to another. Then I wasnt able to see the database.

 

I changed the adminincludesconfigure.php to have the new database location.

Since doing that the orders can be made through the checkout process, they are sent as emails, but they are not visible for either myself or the customer.

 

The way I can see it - is to open up the admin > orders and type the number of the order (I only know this because of the email). I can edit it there but I cannot make it visible in my orders list.

 

Its very strange indeed.

 

Any ideas?

[mattice]

So what do you see in the TABLE orders in the DATABASE?

Forget the Admin / Catalog stuff, look in the db first to see if all is well.

Get phpMyAdmin installed.

 

Look at the orders DB... especially at the order_id fields...

Something must have gone wrong with that... or it seems.

 

Mattice

[Guest]

What do I need to check - I havent touched the database, but I have phpmyadmin - what should I be looking for?

[mattice]

Try to see the 'new made not showing order'-s ID in the table order.

There might be a gap... should be +1 every time. So if you have 1,2,3,7, 4,5 etc you have a problem.

 

If that is okay check the php queries on the actual pages where it goes wrong. See if you get a result if you put that query on the DB directly through phpMyAdmin...

 

You didn't by any change upgraded any pages recently?

New checkout etc? Or did you use a backup recently?

[Mark Evans]

What do I need to check - I havent touched the database, but I have phpmyadmin - what should I be looking for?

 

A good place to check is the orders_status table to make sure there are some records in there.

 

If not insert the default values from the oscommerce.sql file.

[Guest]

This is the database in a nut shell. These are the default settings on it.

 

Anywhere I need to edit it?

 

Hope this makes sense - cause it means not much to me :(

 

 

Database mgs - table orders_status running on localhost

[ Browse ]    [ Select ]    [ Insert ]    [ Empty ]       [ Drop ]  

 

     Field  Type Attributes Null Default Extra Action  

  orders_status_id  int(11)   No  0    Change  Drop  Primary  Index  Unique  Fulltext  

  language_id  int(11)   No  1    Change  Drop  Primary  Index  Unique  Fulltext  

  orders_status_name  varchar(32)   No      Change  Drop  Primary  Index  Unique  Fulltext  

With selected:     Or    

 

 

   Indexes :  

Keyname Type Cardinality Action Field  

PRIMARY  PRIMARY  7   Drop  Edit  orders_status_id  

language_id  

idx_orders_status_name  INDEX  None   Drop  Edit  orders_status_name  

 

Create an index on  columns      Space usage : Type Usage  

Data 204 Bytes  

Index 3,072 Bytes  

Total 3,276 Bytes  

  Row Statistic : Statements Value  

Format dynamic  

Rows 7  

Row length ? 29  

Row size  ? 468 Bytes  

 

 

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

 

Print view

        Run SQL query/queries on database mgs  :

 

SELECT * FROM `orders_status` WHERE 1

 Show this query here again  

 

Or Location of the textfile :

 

 

 

 

   Add new field :   At End of Table At Beginning of Table After orders_status_id After language_id After orders_status_name  

   Alter table order by :  orders_status_id language_id orders_status_name   (singly)  

Insert data from a textfile into table

   View dump (schema) of table

Structure only  

Structure and data  

Data only  

CSV for Ms Excel data  

CSV data :

     Fields terminated by    

     Fields enclosed by    

     Fields escaped by    

     Lines terminated by       Add 'drop table'

Complete inserts

Extended inserts

Enclose table and field names with backquotes

 

Save as file (  "zipped"   "gzipped" )  

Starting row    -- Number of rows    

 

 

    Rename table to :    

     Move table to (database.table):  

 mgs  .    

 

       Copy table to (database.table):  

mgs  .    

Structure only  

Structure and data      

 

 

Table maintenance :  Check table    -  Analyze table    

 Repair table    -  Optimize table    

 

 

   Table comments :        

   Table type :   MyISAM Heap ISAM Merge    

Flush the table ("FLUSH")  

 

 

Drop table

[Guest]

Hi James

 

I writing regarding the post http://www.oscommerce.com/forums/viewtopic.php...8331&highlight= as i have exactly the same problem. Have you resolved this issue, if so how?

 

Thanks

 

DJ Millward

[Guest]

Has anyone else had this happen to them. Or can think what may have happened in transfer of the site.