Installed, but error at top of page

[miktor]

I installed WHM Autopilot by following the instructions. Everything went smooth but when I made an account and logged in to admin this is the error at the top of every page:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mtorosya/public_html/host/tools/step_one_code[0].php on line 258

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mtorosya/public_html/host/tools/step_one_code[0].php on line 300

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mtorosya/public_html/host/inc/step_one_tables.php on line 14

Help, please?

[herpherp]

Did you setup the mysql? Looks like maybe the password or login is incorrect or not setup.... ( I don't personally use whmap but that would be my guess)

[miktor]

Originally Posted by herpherp

Did you setup the mysql? Looks like maybe the password or login is incorrect or not setup.... ( I don't personally use whmap but that would be my guess)

I don't think it is a MySQL password problem since the script accessed it during installation and created a user. I think I will reinstall it completely and see what happens...unless there is an easier way to fix it

[miktor]

I reinstalled...I get the same error

any ideas?

[slapshotw]

Originally Posted by miktor

I don't think it is a MySQL password problem since the script accessed it during installation and created a user. I think I will reinstall it completely and see what happens...unless there is an easier way to fix it

I would reinvestigate here. I'm pretty sure mysql scripts can't create Database users. You give them db user information, and the script can create tables and such though.

Also, have you tried reassigning the DB user you're using to the table and granting full permissions?

[miktor]

When I said created user, I meant the admin account for WHM Autopilot, not a DB user.

I deleted everything and started with a new database but I got the same error. I think the script works, but it gives that error on all the pages.

[slapshotw]

Have you considered trying WHMCS, that everybody likes a lot more than WHMAP and is also free with your hostgator plan?

[miktor]

Originally Posted by slapshotw

Have you considered trying WHMCS, that everybody likes a lot more than WHMAP and is also free with your hostgator plan?

how do i get that? i was only notified of a free WHMAP license so i went for it.

link or something?

[bcmiller]

http://www.whmcs.com/hostgator/

[miktor]

Originally Posted by bcmiller

http://www.whmcs.com/hostgator/

thanks!

[miktor]

thanks for the recommendation.... WHMCS installed without any problems, it looks cleaner, easier to use, pages load faster, etc.

thanks!

[jrettke1]

whmap

fail

[dgroesch]

With regards to the WHMAP - were you trying to load V2? I have seen other posts stating that the V3 version is not perfect.

With regards to the WHMCS vs WHMAP - which is easier for a new reseller like myself?

Thanks in advance!
Dave

[miktor]

Originally Posted by dgroesch

With regards to the WHMAP - were you trying to load V2? I have seen other posts stating that the V3 version is not perfect.

With regards to the WHMCS vs WHMAP - which is easier for a new reseller like myself?

Thanks in advance!
Dave

WHMAP was isntalled just gave some code at the top of every page. Just looking at it made me confused. WHMCS has a very clean interface that is very easy to setup. (I'm a new reseller too)

[Admin003]

Also getting an error msg when logging into the main administration system:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/account_user/public_html/admin/index2.php on line 225

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/account_user/public_html/admin/index2.php on line 232

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/account_user/public_html/admin/index2.php on line 490

I followed all the instructions, step by step. so i don't think this is a user error on my end. I don't have time to wait for hostgator support, so I'm just going to try installing WHMCS instead. Hopefully, my post can help other figure out this issue. It would be interesting to isolate the problem: find out if the problem lies with the MySQL database or the PHP script.

[WHMAutoPilot]

Sounds like it is missing the plan_specs table in the database.

Run the following query against your database and confirm

CREATE TABLE `plan_specs` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `gid` int(22) NOT NULL default '0',
  `rid` bigint(22) NOT NULL default '0',
  `addon_gid` bigint(22) NOT NULL default '0',
  `whm_id` bigint(22) NOT NULL default '0',
  `package_name` varchar(255) NOT NULL default '',
  `whm_package_name` varchar(255) NOT NULL default '',
  `plan_status` int(1) NOT NULL default '0',
  `monthly_cost` float NOT NULL default '0',
  `quarterly_cost` float NOT NULL default '0',
  `semi_annual_cost` float NOT NULL default '0',
  `annual_cost` float NOT NULL default '0',
  `monthly_pid` varchar(32) NOT NULL default '',
  `quarterly_pid` varchar(32) NOT NULL default '',
  `semi_annual_pid` varchar(32) NOT NULL default '',
  `annual_pid` varchar(32) NOT NULL default '',
  `setup_cost` float NOT NULL default '0',
  `web_space` int(10) NOT NULL default '0',
  `shell_access` int(1) NOT NULL default '0',
  `ftp` int(25) NOT NULL default '0',
  `email` int(25) NOT NULL default '0',
  `email_list` int(25) NOT NULL default '0',
  `sql` int(25) NOT NULL default '0',
  `sub_domain` int(25) NOT NULL default '0',
  `parked_domain` int(25) NOT NULL default '0',
  `addon_domain` int(25) NOT NULL default '0',
  `unique_ip_activate` int(1) NOT NULL default '0',
  `unique_ip_cost` float NOT NULL default '0',
  `cgi_access` int(1) NOT NULL default '0',
  `frontpage` int(1) NOT NULL default '0',
  `bandwidth` int(20) NOT NULL default '0',
  `cpanel_theme` varchar(255) NOT NULL default '',
  `tpp_pro_period` int(20) NOT NULL default '0',
  `com_type` int(1) NOT NULL default '0',
  `com_rate_month` float NOT NULL default '0',
  `com_rate_onetime` float NOT NULL default '0',
  `free_trial` int(1) NOT NULL default '0',
  `free_trial_length` int(2) NOT NULL default '0',
  `ip_addresses` varchar(50) NOT NULL default '',
  `memory` varchar(50) NOT NULL default '',
  `processor` varchar(50) NOT NULL default '',
  `os` varchar(50) NOT NULL default '',
  `display_text` text NOT NULL,
  `dedicated` int(1) NOT NULL default '0',
  `in_stock` int(5) NOT NULL default '0',
  `internetsecure_period` int(20) NOT NULL default '0',
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM COMMENT='Plan Specifications' AUTO_INCREMENT=1 ;

Thanks.

[gpembert]

Worked Great I added that table and all the errors were gone! Thanks so much!

[virtualclues]

Thanks for the query fix! It worked. Support told me to reinstall it and I did and all I needed to do was this fix. Ugh! Now let's just see if I can figure out the rest of the program.

[knorr]

It fixed my error too.