Incorrect information in file: 'ac_companies.frm'

Page: 1

Homepage » Forum Index » activeCollab 0.7.1 / Community Technical Support » Incorrect information in file: 'ac_companies.frm'

RSS Icon Recent posts in this topic

stiki on Sep 8. 2007. 9:08 am

I've been using activeCollab for over a month without any problems, but now I can't access it and I get nothing more then a Fatal Error message.

ERROR DETAILS (after setting debug to true):
==============================

ERROR PARAMS
-------------------
File: /home/torontot/public_html/stikimedia/clientsection/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 371
Sql: SELECT * FROM `ac_companies` WHERE `client_of_id` = '0'
Error number: 1033
Error message: Incorrect information in file: './torontot_collab1/ac_companies.frm'

BACKTRACE
---------------
#0 /home/torontot/public_html/stikimedia/clientsection/environment/library/database/adapters/AbstractDBAdapter.class.php(289): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/torontot/public_html/stikimedia/clientsection/environment/library/database/DB.class.php(171): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/torontot/public_html/stikimedia/clientsection/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /home/torontot/public_html/stikimedia/clientsection/application/models/companies/base/BaseCompanies.class.php(101): DataManager->find(Array)
#4 /home/torontot/public_html/stikimedia/clientsection/environment/classes/dataaccess/DataManager.class.php(223): BaseCompanies->find(Array)
#5 /home/torontot/public_html/stikimedia/clientsection/application/models/companies/base/BaseCompanies.class.php(135): DataManager->findOne(Array)
#6 /home/torontot/public_html/stikimedia/clientsection/application/models/companies/base/BaseCompanies.class.php(137): BaseCompanies->findOne(Array)
#7 /home/torontot/public_html/stikimedia/clientsection/application/models/companies/Companies.class.php(33): BaseCompanies::findOne(Array)
#8 /home/torontot/public_html/stikimedia/clientsection/application/models/CompanyWebsite.class.php(62): Companies::getOwnerCompany()
#9 /home/torontot/public_html/stikimedia/clientsection/application/models/CompanyWebsite.class.php(45): CompanyWebsite->initCompany()
#10 /home/torontot/public_html/stikimedia/clientsection/application/models/CompanyWebsite.class.php(49): CompanyWebsite->init()
#11 /home/torontot/public_html/stikimedia/clientsection/application/application.php(21): CompanyWebsite::init()
#12 /home/torontot/public_html/stikimedia/clientsection/init.php(125): require_once('/home/torontot/...')
#13 /home/torontot/public_html/stikimedia/clientsection/index.php(9): require('/home/torontot/...')
#14 {main}

Let me know if you need me to post the Autoglobal Variables generated by the debug page.

PS: I don't know if this will help, but I have marked the "keep me logged in for 14 days" on the login screen", so I never have to go through the login screen, I'm always automatically forwarded to my dashboard page.

Thanks,
Igor

Ilija Studen on Sep 8. 2007. 9:27 am

There is something wrong with the database. Try to repair ac_companies table (there should be repair function in phpMyAdmin).

If that doesn't help try searching for "Incorrect information in file: ..." MySQL error on Google and see what people suggest as a solution.

activeCollab team member | LinkedIn

stiki on Sep 8. 2007. 9:53 am

You are absolutely right, my database table is currupt. Repair didn't work. Will re-creating the table manually help.? if so, could you give me the DDL so i can run it and populate the ac_companies table manually.

I'm still looking up the error information on google, I'll post back here when I find something.

Thanks,
Igor

Ilija Studen on Sep 8. 2007. 9:59 am

Recreation of table will help if you know what data was inside. Empty table is useless and you'll end up with really bad error (Owner company not defined at least)

Here is DDL, but I would recreate it only if any other option fails (see with your hosting provide for backup at least):

CREATE TABLE `ac_companies` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`client_of_id` smallint(5) unsigned default NULL,
`name` varchar(50) collate utf8_unicode_ci default NULL,
`email` varchar(100) collate utf8_unicode_ci default NULL,
`homepage` varchar(100) collate utf8_unicode_ci default NULL,
`address` varchar(100) collate utf8_unicode_ci default NULL,
`address2` varchar(100) collate utf8_unicode_ci default NULL,
`city` varchar(50) collate utf8_unicode_ci default NULL,
`state` varchar(50) collate utf8_unicode_ci default NULL,
`zipcode` varchar(30) collate utf8_unicode_ci default NULL,
`country` varchar(10) collate utf8_unicode_ci default NULL,
`phone_number` varchar(30) collate utf8_unicode_ci default NULL,
`fax_number` varchar(30) collate utf8_unicode_ci default NULL,
`logo_file` varchar(44) collate utf8_unicode_ci default NULL,
`timezone` float(2,1) NOT NULL default '0.0',
`hide_welcome_info` tinyint(1) unsigned NOT NULL default '0',
`created_on` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by_id` int(10) unsigned default NULL,
`updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
`updated_by_id` int(10) unsigned default NULL,
PRIMARY KEY (`id`),
KEY `created_on` (`created_on`),
KEY `client_of_id` (`client_of_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

activeCollab team member | LinkedIn

stiki on Sep 8. 2007. 10:13 am

Thanks for the quick response, but I just realized its worse then this. All my tables for this database are corrupt. I have other databases on my server and they are fine, its only the activeCollab DB thats been corrupted.

I guess a reinstall is in order, but would have any idea of why this might have happened? Would you recommended that I back up my activeCollab database in the future so that I can revert if a problem like this happends again untill you release version 1.

Thanks alot Ilija,
Igor

stiki on Sep 8. 2007. 10:29 am

I read somewhere that this error message could be caused because the tmp directory on the MySql server had changed permissions automatically. I'm hosting using Cpannel and the rest of my databases are running fine.

- Does each database have its own tmp directory?
- Could this be the problem, should I contact my host?

Cheers,
Igor

Ilija Studen on Sep 8. 2007. 11:28 am

I really don't have much experience with managing MySQL in production so I can't help you much :(

Contact your hosting provider or ask on specialized forums / mails lists.

activeCollab team member | LinkedIn

stiki on Sep 8. 2007. 11:56 am

I understand, and I'm very glad that you take time to answer all the posts.

Could you just tell me if there could be a bug in activeCollab that corrupted the database, or if you are pretty sure it had something to do with my host.

Ilija Studen on Sep 8. 2007. 2:04 pm

Really don't know. activeCollab sends perfectly valid SQL commands and other people are not complaining that activeCollab broke their entire database (I think we would notice such thing :D ). And yeah, I'm not saying that it's your hosts fault or anything like that.

If you find out what happened please report back.

activeCollab team member | LinkedIn

#10

ajwagner on Sep 13. 2007. 5:20 pm

I am having the same problem and I am contacting my host to see if they have any insight.

Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.

RSS Icon Recent posts in this topic

Homepage » Forum Index » activeCollab 0.7.1 / Community Technical Support » Incorrect information in file: 'ac_companies.frm'