Lost information staff members

Started by ben, September 19, 2013, 10:41:42 AM

ben

When I access the staff members I get a character in each field, I can not see the employee information and I can not edit or delete them.

Which may be due to this? Any change in the tables in the database?

Thank you very much.

tallship

What was the very last thing you did before this happened?


Can you roll back to the previous days snapshot?


What happened when you did a:



# mysql -u root -p[root_password] [database_name] < dumpfilename.sql
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.

ben

When we detect the error already had made ​​changes to the database and could not restore the snapshot.

I connect properly to the database and all the user information appears correctly.

Can be problem HostBill php files?

Thank you very much.

tallship

Gosh I don't know. But if you just do a restore from an earlier backup of your MySQL database, and then unzip the previous version of HostBill corresponding to that backup, you'll be fine.
Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.

nibb

No, is not hostbill files, but your database. Its probably corrupted or someone messed it up.

Hostbill like any PHP software that uses MySQL just pulls data out of your database, if that is what you see, its because probably that is exactly what you have in the database. Just to be sure, I would actually check in your database if the data is there or not.

ben

Thanks for the replies.

I checked the database and was correct, the designer had modified a file and broken php page.

tallship

Bradley D. Thornton - Manager Network Services, NorthTech Computer   TEL: +1.310.388.9469 (US) | +44.203.318.2755 (UK) | +61.390.088.072 (AU) | +41.43.508.05.10 (CH)
Registered Linux User #190795 - "Ask Bill why the string in [MS-DOS] function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Dr. Gary Kildall.