Strange Screen output when checking installed packages on aps-installer

Discussion in 'Installation/Configuration' started by ClaudioP, Aug 3, 2016.

  1. ClaudioP

    ClaudioP New Member

    This is weird, everything was working fine, i have 3 other wordpress installations working fine, but then after i installed the 4th one, when i get back to check what are the installed packages i get this output below, also, now i can´t install other packages using the aps- installer.
    everything else works fine except the installed packages page.
    ISPCONFIG version -> 3.0.5.4p9
    The weird output is this one below:
    #0 db->query(SELECT aps_instances.id AS id, aps_instances.package_id AS package_id, aps_instances.customer_id AS customer_id, sys_group.name AS customer_name, aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, aps_packages.version AS package_version, aps_packages.release AS package_release, aps_packages.package_status AS package_status, CONCAT((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id), '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) AS install_location FROM aps_instances, aps_packages, sys_group WHERE sys_group.client_id = aps_instances.customer_id AND aps_instances.package_id = aps_packages.id and aps_packages.name LIKE '%wordpress%' ORDER BY package_name LIMIT 0, 15) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211] #1 db->queryAllRecords(SELECT aps_instances.id AS id, aps_instances.package_id AS package_id, aps_instances.customer_id AS customer_id, sys_group.name AS customer_name, aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, aps_packages.version AS package_version, aps_packages.release AS package_release, aps_packages.package_status AS package_status, CONCAT((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id), '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) AS install_location FROM aps_instances, aps_packages, sys_group WHERE sys_group.client_id = aps_instances.customer_id AND aps_instances.package_id = aps_packages.id and aps_packages.name LIKE '%wordpress%' ORDER BY package_name LIMIT 0, 15) called at [/usr/local/ispconfig/interface/web/sites/aps_installedpackages_list.php:112]

    Thank you all in advance!
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The database might be corrupted. Try to run a repair in all tables in the dbispconfig database with phpmyadmin.
     
  3. ClaudioP

    ClaudioP New Member

    Thank you till, but it didn´t solve the problem.
    I did some digging it turned out to be quite simple, the disk got filled while i was logged in on the Interface, once i logged out i couldn´t get in anymore, so i started to dig, then after a simple df -H i found out that the disk was full, so most likely the db was having trouble, to test my theory i rebooted the server(easier and faster than digging through log files), and mysql would not start anymore, i cleaned the disk and everything is back to normal.
    But thank you for your answer anyway, i never knew that we could repair ispconfig tables, that one i´ll save for the future.
     

Share This Page