Orders module - orders no longer displaying

[Tino]

I set up an e-commerce site using Calguy's suite of modules. Everything worked fine, couple of teething problems but we got there. The orders came in, and there were no problems. But now all the orders have disappeared from the Order Manager, including ones that used to be visible.

New orders are still coming, payments are being processed, notification emails are going out, but when you log onto the site and go into Order Manager, none of them are being displayed. Even searching for the order number returns nothing.

I hadn't done any site maintenance when this problem occured, so that's not the cause, however the site versions are fairly out of date (see below). So to try and rule that out, I've taken a copy of the site to a dev server (with the same hosts as the original), and upgraded it to all the latest versions, but I still can't see any of the orders.

I know very little about databases to be able to tell if the information is still in there and just not displaying, or whether it has gone completely.

Any help greatly appreciated, thanks.

Info on live site (i.e. not the dev copy I've made, it's on latest version of everything as of today)

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

Cms Version: 1.7

Installed Modules:
CMSMailer: 1.73.14
FileManager: 1.0.2
MenuManager: 1.6.2
ModuleManager: 1.3.3
News: 2.10.4
nuSOAP: 1.0.1
Printing: 1.0.4
Search: 1.6.2
ThemeManager: 1.1.1
TinyMCE: 2.6.5
CGExtensions: 1.18.8
FrontEndUsers: 1.8.5
CGSimpleSmarty: 1.4.4
CustomContent: 1.5.3
CGEcommerceBase: 1.1.1
Products: 2.8.2
CGPaymentGatewayBase: 1.0.5
Cart: 1.6.2
Captcha: 0.4.3
Orders: 1.8.6
SelfRegistration: 1.4.2
DestinationBasedShipping: 1.1
PaypalGateway: 2.1.7
PriceBasedShipping: 1.0.2
FormBuilder: 0.6.4


Config Information:
php_memory_limit:
process_whole_template: false
max_upload_size: 10000000
default_upload_permission: 664
assume_mod_rewrite: false
page_extension:
internal_pretty_urls: false
use_hierarchy: true


Php Information:
phpversion: 5.2.17
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
E_STRICT: 0
memory_limit: 24M
max_execution_time: 60
safe_mode: Off (False)
session_save_path: /tmp (1777)
session_use_cookies: On (True)


Server Information:
Server Api: cgi
Server Db Type: MySQL (mysql)
Server Db Version: 5.1.56


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

[Tino]

Does anyone have any ideas on this? I'm completely stuck??

Thanks,
Tino

[Tino]

I'm really desperate for a bit of help on this one, I'm at a complete loss as to what might be the problem.

If anyone thinks they need more information to help please let me know and I can provide it.

Thanks in advance.

[flatcap1]

I'm getting the same problem. It my have happened after I deleted each of the orders one by one.

I can see there are orders in the database table "module_orders" but they're just not appearing. I've been comparing this table with one on by local system which does show the orders.
Strangly, if you type in an invoice number (must be an interger), e.g. 42, and submit then the matching order does appear.

I'll look at this some more tomorrow, but like you I need this resolving soon.

[flatcap1]

I've copied the code and database to my local development area and the orders appear fine! The only difference is the environment which must be affecting the results of the SQL expression.