Good question... I dunno what is the right answer. I'll do some poking around and get back to you if I got an useful answer. You should email the people at Verisign as they probably could assist you..
You could use the contribution about finding lost orders in your database..
Are the old customers showing OK ?
I've also the same issue.
Migrated from php4.1 to 4.4 , mysql 4 to mysql 5, sarge to Etch.
Everything work ok but the order.php.
The database is recording order properly.
I feel the issue comes from the SQL command line line 355 of orders.php.
I'm not able to correct ..
Did you have any luck finding the issuer ? .
I'm still stuck in front of a non working system..
I had something like this ages ago, from memory it ended up being a missing Order Status that had been removed, but the orders were set to that. So it had a blank field and would not display them in admin, but did in mysql.
Place a new order and see if it shows up in orders in admin, if it does then your old orders are missing something so compare them in mysql and look for a blank field which might be in order status or something else.
For me I had removed a status and adding this back gave me all my orders back.
This post has been edited by.
: 19 December 2008, 02:00..
Wanneer ik naar Klanten ga dan zie ik WEL de nieuwe klanten die een order hebben geplaatst..
Wanneer ik naar Orders ga zie ik daar niet de bijbehorende orders.....
Alles werkt voor de rest..
Wat kan het zijn alles werkt voor de rest, en de shop is al live...
When I go to Customers, then I DO see the new customers wich placed a order..
But when I go to Orders, then I don't see the related orders. I do see the old ones placed before the migration..
The rest works fine..
What can it be ? de shop is already live so any quick help would be appreciated..
This post has been edited by.
: 19 December 2008, 12:33..
Check in MYSQL to see if you can see the new orders there. If so make a note of the order number and go into admin.
Then browse to.
/admin/orders.php?selected_box=customers&page=1&oID=1498&action=edit replace 1498 with your order number.
See if the order comes up then. if it does you might see something strange or missing, like an order status or something. this should help you track down the problem..
This post has been edited by.
: 19 December 2008, 12:47..
Done it. I don't seem to miss anything... everything looks fine......tryed many order numbers......
Try changing one of the order status in admin and see if it then shows up in the normal list..
Personnaly i'm wonderning if my problem does nto come from a French Version of the Admin.
I was able to let the admin panel display the number of pending order in the small left box (main page of the admin).
The issue was a non proper filling of the orders_status table , which I corrected this way:.
(3, 1, 'Delivered'),.
(2, 1, 'Processing'),.
(1, 1, 'Pending'),.
(1, 4, 'En attente'),.
(2, 4, 'En cours'),.
(3, 4, 'Livr');.
The 3 last lines were the french translation.
Now the box displays the pending number of order properly.
But when I click on the link (/admin/orders.php?selected_box=customers&status=1)I get nothing.
Admin/orders.php?status= list no orders.
Do not mist anothing at all..
/shop/account_history_info.php?order_id=10 does list a pending order with the appropriate status : Pending.
This issue is driving me crazy ..
I'm thinking of zapping the all code and restart from scratch (but do nto want to loose hours).....
My feeling is I've done something wrong in the table configuration. But as I'm not an expert, I cannot figure out..
If it helps, some content of my tables.
INSERT INTO `orders_status_history` (`orders_status_history_id`, `orders_id`, `orders_status_id`, `date_added`, `customer_notified`, `comments`) VALUES (10, 10, 1, '2008-12-20 09:13:10', 1, 'customer remark');.
INSERT INTO `orders` (`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES.
(10, 3, 'philippe cadic', 'coucou', 'street', '', 'ORLEANS', '45160', 'loiret', 'France', '3873768376376', '', 1, 'philippe cadic', 'coucou', '7 Street', '', 'ORLEANS', '44160', 'loiret', 'France', 1, 'philippe cadic', 'coucou', '7Street midi', '', 'ORLEANS', '44160', 'loiret', 'France', 1, 'Paiement par chèque', '', '', '', '', NULL, '2008-12-20 09:13:10', 1, NULL, 'EUR', 1.000000),.
System is: PHP4.4, Mysql5, Etch 64 bits, Apache 2.
OsCommerce version: $Id: application_top.php,v 1.280 2003/07/12 09:38:07 hpdl Exp $.
The french package was installed (.
I have the same problem.
Orders are placing in mysql but are not showing in orders.php.
I can see the order when I try this address :.
I changed status of one of them but nothing happend !.
Please let me know what's the problem , it makes me crazy !..
I just found the problem.
It's really stupid !.
See both configure files ,.
There is differnece between.
That's it !!!..
But what is the right thing do do ? everything with or without www ?
All of them should be the same , for me it's without www..
I migrated my hole Verisign site to a new server with new php and mysql versions. I have done this before..
Everything looks fine, and works fine, except one thing..
I don't see my orders in the admin. The rest of the Verisign website is working 100%..
When I login to the database it shows them just fine..
Searched on the forum but couldn't find any related topics..
This Verisign site is live now and I can't go back. Please help me ASAP..