New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
I dont have any... Its bizzare.
I moved the www dir reinstalled mysql and dragged the myi* files in.
Now only half of the panel works, and I mean just half does not randomly work.
Works (New orders, tickets)
Broken (Invoicing, Promotions, changing plans.)
http://dev.mysql.com/doc/refman/5.0/en/check-table.html
Try running this.
Nope, still broken.
delete contents of templates_c/
Also, why didn't you just mysqldump the db to a file then import it?
I was in a super super hurry
I thinking if you do a MySQL dump properly it will most likely work.
Old server was trashed... If I dump my current DB and restore will it have the same effect?
It could or it could fix it. Worth a try!
We had this really weird problem where we had to hard refresh our system for WHMCS to show any changes. Might be your case here. We had no idea what was the issue, and just gave up on it.
Now we have a issue where WHMCS redirects us back to the login page for admin nomatter what we imput.
I swear, WHMCS is really on my nerves.
Hard refresh?
Tick the remember password box, also insure you have register_globals off
Where are your WHMCS db backups? I have them emailed to me nightly.
... that seems an unnecessary load on a mailserver. Why not use a more efficient means to backup large SQL dumps?
Stop it now, you know to be totally hipster you need to use the Email File Transfer Protocol (eFTP)
I used to do that but now I use crashplan
Did the trick, thanks!
@Aldryic who says he has large sql dumps?
Why bash a feature that WHMCS provides? lol.
@bijan588 k, so if you have backups and it's still not working maybe it's something else, forget a module on the new server, but you would think it would impact everything.
error_log reveal anything, or go into WHMCS and turn the sql debugs and see what's going on.
I was being polite.
I'm not bashing it. It just makes no sense if you have a decent sized database:
You're relying on the WHMCS Cron for this. While I typically have no problems there, I have run across instances where bad data or even just the cpanel module wanting to be a dick can halt the cron midway through. Which would mean no backups for you that day.
You're relying on a single system for backups. Perhaps I'm a bit paranoid, but we retain SQL dumps (X hour, daily, weekly, monthly) in three different (secured) locations. If you were to catch a bad fsck right before Cron, you're taking the chance of losing everything that happened from the prior day (since you would lose that day's backup as well)
Why would you want to tie up an email server with a file that large? (I'm assuming, anyways... a single sqldump for ours is ~920meg now). And why would you want to make WHMCS sit and wait for that mail to be pushed through before it can move on?
Just my two cents, anyways.
umm... gzip anyone?
That would be after compression, sir.
What, your customers submit their porn collections as tickets and you archive them?
That would make for a much more interesting day :P
@bijan588: Is it things that end in *.cgi?
systemcleanup.php :P
Already run regular scheduled cleanup, sir
What have you borked on it then? My compressed dumps are 14mb, unless you have your p0rn collection stored in there
Borked? Nothing at all. I simply treat data retention differently, is all. You have your policies, I have mine :P
Woa woaaaa! Stop fighting kids XD
Seriously u_u