ispCP - Board - Support
Table 'ispcp.domain_id' doesn't exist - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Table 'ispcp.domain_id' doesn't exist (/thread-7664.html)



Table 'ispcp.domain_id' doesn't exist - haj - 08-27-2009 08:04 PM

I am having a little problem with ispCP..

I'm running on Debian Lenny, and installed ispCP 1.0.2 using the installation-guide and has tried installing twice.. because I thought I might have messed up during the first install.

After I have been using ispCP a bit, set up a test-reseller and a test-user, it starts to give me this error when trying to switch to the reseller from the admin-login.

Warning: Missing argument 4 for records_count(), called in /var/www/ispcp/gui/include/reseller-functions.php on line 529 and defined in /var/www/ispcp/gui/include/admin-functions.php on line 1005

Notice: Undefined variable: value in /var/www/ispcp/gui/include/admin-functions.php on line 1010

Table 'ispcp.domain_id' doesn't exist

I have tried searching for this error on google and didn't find anything usefull... Any hints on what is wrong?


RE: Table 'ispcp.domain_id' doesn't exist - WuChEn - 08-27-2009 08:26 PM

Open File:

/var/www/ispcp/gui/include/reseller-functions.php

and change line 529

$sql_db_current = records_count( 'sql_database', 'domain_id', $user_id);

to

$sql_db_current = records_count('sqld_id', 'sql_database', 'domain_id', $user_id);

greatz WuChEn


RE: Table 'ispcp.domain_id' doesn't exist - haj - 08-27-2009 08:41 PM

Nice.. thank you Smile