Page 2 of 2
Re: List of files is empty
Posted: 05 Aug 2011, 16:26
by Jan
Hi, it is a database error, which can be easily displayed by enabling debug mode in the configuration of Joomla!
Jan
Re: List of files is empty
Posted: 09 Aug 2011, 09:55
by erijsewijk
jenhol wrote: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?
Re: List of files is empty
Posted: 10 Aug 2011, 01:07
by 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
Re: List of files is empty
Posted: 11 Aug 2011, 05:47
by 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
}
}
Re: List of files is empty
Posted: 11 Aug 2011, 16:52
by 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
Re: List of files is empty
Posted: 12 Aug 2011, 11:16
by 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
Re: List of files is empty
Posted: 19 Aug 2011, 15:33
by 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!
Re: List of files is empty
Posted: 21 Aug 2011, 00:37
by Jan
Ok, thank you for the info. Jan