Not showing pending orders?

[ByteCubeHosting]

Hi there,

 

I have an issue with my WHMCS install. It won't show the pending orders at the top of the admin panel, however it will show the amount of support tickets that need replying and the amount of overdue invoices. (see image)

 

 

When I first set it up, I tested everything was working by making some test orders. I then deleted these from the database, along with anything hat related to it (invoices etc). I can't seem to look at the PHP either because of the fact that it's all encoded with Ioncube:idea:

 

Anyone got any ideas on how I can fix this issue?

 

Many Thanks!

 

- - - Updated - - -

 

Please note that in the above picture, you would expect a number to the left of pending orders. It isn't there!

[brian!]

I take it you do actually have pending orders? even if you didn't, it should show '0'... the fact that isn't even showing would make me think that may have deleted something that you shouldn't.

 

did it ever show a value for pending orders or has it always been blank?

[ByteCubeHosting]

I take it you do actually have pending orders? even if you didn't, it should show '0'... the fact that isn't even showing would make me think that may have deleted something that you shouldn't.

 

did it ever show a value for pending orders or has it always been blank?

 

Yes, it did show a value before. All I deleted was the data inside a few tables, as I wanted to "reset" the orders and such. The increments still started from a higher number (Order 11 or so), so could it be because order 1 doesn't exist?

 

I can't see the code so I can't take a look into what should/shouldn't be there.

[brian!]

Yes, it did show a value before. All I deleted was the data inside a few tables, as I wanted to "reset" the orders and such.

I like the way you casually say... "all I deleted was the data inside a few tables" - that can be a dangerous thing to do if you don't know what you're doing with WHMCS.

 

what I would suggest is to open a ticket with Support and they may take a look at your database - perhaps they'll be able to fix it with a SQL update query to the appropriate tables.

[ByteCubeHosting]

I like the way you casually say... "all I deleted was the data inside a few tables" - that can be a dangerous thing to do if you don't know what you're doing with WHMCS.

 

what I would suggest is to open a ticket with Support and they may take a look at your database - perhaps they'll be able to fix it with a SQL update query to the appropriate tables.

 

Agreed, but I am not new to PHP/MySQL etc so it's not like I've gone in and dropped the entire database. Just difficult to correct myself when the code is encoded!

 

I'll open a ticket, thanks for your help.

[brian!]

Agreed, but I am not new to PHP/MySQL etc so it's not like I've gone in and dropped the entire database.

I appreciated that and could tell you knew what you were doing in general with databases - it's just that with WHMCS you have to be so careful when deleting things directly in the database... especially when it comes to the orders/invoices tables... if in doubt, it's safer to delete via the admin area rather than directly.

 

to be honest, I did the same thing myself years ago when I first bought WHMCS - so it's easily done... but I hadn't gone live at that stage, so I just deleted the database, started again and reimported my data from my old billing software.

 

there are plenty of things that you'll do in the first few months that you think make logical sense, but goes against how WHMCS works... so it's always good to have db backups available!