Hi,
I'm trying to create my own module. Basicaly, it should work only with Xhelp and provide statistics and reports about ticketing. I'm at an early stage of developpement. I'm now trying to add a MySQL script to be runned during the installation / update of this module.
I followed the docs i've found, added lines in the xoops_version file like this :
// Sql file (must contain sql generated by phpMyAdmin or phpPgAdmin)
// All tables should not have any prefix!
$modversion['sqlfile']['mysql'] = "sql/mysql.sql";
// Tables created by sql file (without prefix!)
$modversion['tables'][0] = "xhs_lur";
$modversion['tables'][1] = "xhs_reports";
I've the mysql.sql script in the right path, with the right perms (apache:apache 755).
When I launched the update process in the "Modules/Administration" page, I clique again in the following confirmation page, everything works fine, except the MySQL instructions seems to be bypassed. and no tables are created.
I've even tried to delete the file mysql.sql, but it chenge nothing, as if the sql part of xoops_version.php were useless.
when I try to run script directly in phpmyadmin, it's ok. The tables are created so i dont think it's a MySQL syntax problem.
I guess I skipped 1 step in the procedure, but I can't get it !
Here's my conf (thanks modinfo):
XOOPS Version:
XOOPS 2.2.3 Final
XOOPS Theme:
default
XOOPS Template Set:
default
PHP Version:
5.0.4
MySQL Version:
4.1.14
Server Software:
Apache/2.0.54 (Fedora)
User's Browser:
Mozilla/5.0 (Windows; U; Windows NT 5.0; fr; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1
When I enable debug console for MySQL and php, I got nothing , no errors. The only thing I got with the debug enable are warnings about others modules ("Warning [PHP]: xoops_load_lang_file").
That's it. If anyone can enlight me, it would make me happy in this rainny day...
thx