Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Multiple problems - install and post-install
(1 viewing) (1) Guest
Document management system (DMS) component for Joomla!

If your topic falls within one of the subcategories, then please post it directly there. Post to this parent category only if your question does not match any subcategory topic.
  • Page:
  • 1

TOPIC: Multiple problems - install and post-install

Multiple problems - install and post-install 14 years, 11 months ago #9608

Environment:
Joomla 1.5.14 (native)
PHP 5.2.11
MySQL 4.0.27

I downloaded com_joomdoc-2.0.2.zip and used the Upload Package File in Extension Manager to upload/install.

A lot of installation success messages, then I see:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homepages/nn/xxxxxxxxxx/htdocs/www/libraries/joomla/database/database/mysql.php on line 344

When I try to migrate from DOCman 1.4 (we were running in legacy mode), I see:

SOME_ERROR_CODE - An error has occurred.
Migration not successfully.

In the Control Panel, under Unapproved Documents, I see:

Warning: Invalid argument supplied for foreach() in /homepages/nn/xxxxxxxxxx/htdocs/www/administrator/modules/mod_joomdoc_approval/mod_joomdoc_approval.php on line 44

Clicking on Documents, I get:

DB function failed with error number 1146
Table 'joomladb.jos_joomdoc' doesn't exist SQL=SELECT count(*) FROM jos_joomdoc AS a

Clicking on Groups, I get:

Table 'joomladb.jos_joomdoc_groups' doesn't exist SQL=SELECT count(*) FROM jos_joomdoc_groupsDB function failed with error number 1146
Table 'joomladb.jos_joomdoc_groups' doesn't exist SQL=SELECT * FROM jos_joomdoc_groups ORDER BY groups_name LIMIT 0, 10

Clicking on Licenses, I get:
Table 'joomladb.jos_joomdoc_licenses' doesn't exist SQL=SELECT count(*) FROM jos_joomdoc_licenses
Warning: Invalid argument supplied for foreach() in /homepages/nn/xxxxxxxxxx/htdocs/www/administrator/components/com_joomdoc/includes/licenses.php on line 130
DB function failed with error number 1146
Table 'joomladb.jos_joomdoc_licenses' doesn't exist SQL=SELECT id, name, license FROM jos_joomdoc_licenses ORDER BY name LIMIT 0, 10

Clicking on Statistics, I get:
Warning: Invalid argument supplied for foreach() in /homepages/nn/xxxxxxxxxx/htdocs/emm/administrator/components/com_joomdoc/includes/docman.html.php on line 143

Clicking on Download Logs, I get:
DB function failed with error number 1146
Table 'joomladb.jos_joomdoc_log' doesn't exist SQL=SELECT count(*) FROM jos_joomdoc_log

Any tips/hints/hand-holding are welcomed and will be appreciated.

Thank you!
Last Edit: 14 years, 11 months ago by praktisch. Reason: Change topic
The topic has been locked.

Re:Multiple problems - install and post-install 14 years, 11 months ago #9612

Coming to the conclusion that v2.0.2 has a number of bugs to work out. To get around the problems mentioned earlier and after some bumbling, I did the following:

  1. Decompressed com_joomdoc-2.0.2.zip (if you don't have a good utility, get 7-Zip)
  2. In joomdoc.xml, changed the lines: <installfile>install.docman.php</installfile> <uninstallfile>uninstall.docman.php</uninstallfile> to: <installfile>admin/install.docman.php</installfile> <uninstallfile>admin/uninstall.docman.php</uninstallfile> This may not be necessary for your version of Joomla! Click here and here for related info. Noted that even the version string hadn't been updated from 2.0.1. Not an error source, but perhaps a little desperate to get something released?
  3. Zipped the changes. It's very important to preserve the original folder/file structure when doing this. 7-Zip's explorer extensions make this boringly easy. Use Windows explorer to navigate inside the decompressed folder, com_joomdoc-2.0.2. Press CTRL+A to select all files/folders. Right-click the selection and choose 7-Zip -> Add to "com_joomdoc-2.0.2.zip"
  4. Made sure System Legacy plugin is disabled (running Joomla! 1.5.14 native) and previous installs of Joomdoc removed, though DOCman 1.4 is still installed--I want to migrate.
  5. Performed standard Extension Manager -> Upload Package File install. No errors during installation this time, but still no jos_joomdoc tables created, and related errors appear when clicking on the various JoomDocs control panel links. After checking my shared hosting control panel, noted that it would allow me to create a MySQL v5 database. Did so and used phpmyadmin to export/import database structure and records to new database. Also changed configuration.php settings for new host/database/user settings. This time, after installing JoomDocs, the appropriate jos_joomdoc tables were created. Yay!
  6. The two-click migration process completed with no errors. Now, however, when I navigate the actual site and drill down to the document level, the documents that appear are not clickable... I also tried creating a new document thinking that maybe the migration process doesn't work properly. The new document shows up, but the "link" for the document still can't be clicked. If I view source, the opening anchor tag for a document looks like: <a class="dm_name">

<sigh>I'm about to yell "uncle" and go to DOCman 1.5.</sigh>
Last Edit: 14 years, 11 months ago by praktisch.
The topic has been locked.
  • Page:
  • 1
User Login Empty