List of files is empty

[Jan]

Hi, it is a database error, which can be easily displayed by enabling debug mode in the configuration of Joomla!

Jan

[erijsewijk]

Hi again, I turned the debug and display errors on, and now I´ve found what the problem is - the missing column in the database table.

My bad...

Problem solved - thx!

Was the column "a.userid" missing? If yes, how did you exactely fix that?

[Robsn]

Hello erijsewijk,

i had the same problem (missing column "userid") and could solve it. I have no SQL skills and just tried, but i had luck
Pleas do a backup from your SQL-database before you change something.
To solve the problem, follow these steps:
1. Open the phpMyAdmin
2. Look in the table "jos_phocadownload" if the column "userid" is missing. If the column is missing then...
3. Copy this in the SQL-command-box: ALTER TABLE `jos_phocadownload` ADD `userid` int(11) NOT NULL Default '0' AFTER `description` ;

Kind regars

Robsn

[ecolora]

Why it was hard to add some code in install.php in Your new release?

Code: Select all

$db = & JFactory::getDBO();
$jAp=& JFactory::getApplication();

$db->setQuery("select userid from `#__phocadownload`");
            if (!$db->query()) {
                $db->setQuery("ALTER TABLE `#__phocadownload` ADD (
               `userid` int(11) NOT NULL Default '0' AFTER `description`''
	           )");
               if (!$db->query()) {
                $jAp->enqueueMessage(nl2br($db->getErrorMsg()),'error'); //display and convert to HTML when SQL error
               }
            }

[Robsn]

@ecolora:

Maybe we have no hands, to tip the code with the keyboard. Maybe we have never been to school and do not know the "ABC". And maybe some keys are missing on our keyboard.
But i think we have no PHP-skills

Just a joke

[Jan]

Hi,

Why it was hard to add some code in install.php in Your new release?

It is explained in this forum many times, it is not possible to add such upgrade scripts between development versions (rc, beta). The upgrade script between all other versions is working this way.

Jan

[grendizer71]

Hi,
adding the column "userid" using the script (as Robsn wrote) all now works fine . I coming from a RC relase of phocadownload, when not so much extension were avaiable for joomla 1.6

the code proposed by ecolora is interesting, but in any case I suggest to sign this post as solved, many other peolple may use it to solve their problem.
bye and thank you!

[Jan]

Ok, thank you for the info. Jan