Hello, I tried installing this version of Multixoops but get a db error, complete log follows (any help appreciated):
The following two directories are outside the web root folder:
multix2334_lib
multix2334_data
XOOPS documents root physical path: C:/AppServ/www/multix2334
Website location (URL): '.strtolower(XOOPS_PROT.$_SERVER['HTTP_HOST'].'/multix2334').'
Administrator account:
User: mysite
Pasw: ********
email:
eeeee@yahoo.com * Table mtx381_avatar created.
* Table mtx381_avatar_user_link created.
* Table mtx381_banner created.
* Table mtx381_bannerclient created.
* Table mtx381_bannerfinish created.
* Table mtx381_block_module_link created.
* Table mtx381_xoopscomments created.
* Table mtx381_xoopsnotifications created.
* Table mtx381_config created.
* Table mtx381_configcategory created.
* Table mtx381_configoption created.
* Table mtx381_groups created.
* Table mtx381_group_permission created.
* Table mtx381_groups_users_link created.
* Table mtx381_image created.
* Table mtx381_imagebody created.
* Table mtx381_imagecategory created.
* Table mtx381_imgset created.
* Table mtx381_imgset_tplset_link created.
* Table mtx381_imgsetimg created.
* Table mtx381_modules created.
* Table mtx381_newblocks created.
* Table mtx381_online created.
* Table mtx381_priv_msgs created.
* Table mtx381_ranks created.
* Table mtx381_session created.
* Table mtx381_smiles created.
* Table mtx381_tplset created.
* Table mtx381_tplfile created.
* Table mtx381_tplsource created.
* Table mtx381_users created.
* Table mtx381_cache_model created.
* Table mtx381_policies created.
* Table mtx381_newfeeds created.
* Table mtx381_domain created.
* Table mtx381_domaincategory created.
* Table mtx381_domainoption created.
=============
Errors:
Saving your settings to the database
Initial data have been inserted into database.
Press next to go to the next step.
* 1 entries inserted to table mtx381_bannerclient.
* 7 entries inserted to table mtx381_configcategory.
* 34 entries inserted to table mtx381_configoption.
* 1 entries inserted to table mtx381_imgset.
* 1 entries inserted to table mtx381_imgset_tplset_link.
* 7 entries inserted to table mtx381_ranks.
* 17 entries inserted to table mtx381_smiles.
* 3 entries inserted to table mtx381_groups.
* 2 entries inserted to table mtx381_groups_users_link.
* 55 entries inserted to table mtx381_group_permission.
* 1 entries inserted to table mtx381_tplset.
* 1 entries inserted to table mtx381_modules.
* 29 entries inserted to table mtx381_tplfile.
* 29 entries inserted to table mtx381_tplsource.
* 12 entries inserted to table mtx381_newblocks.
* 12 entries inserted to table mtx381_block_module_link.
* 93 entries inserted to table mtx381_config.
?? * Failed inserting 3 entries to table mtx381_banner.
?? * Failed inserting 1 entries to table mtx381_users.
Saving your settings to the database
Initial data have been inserted into database.
Press next to go to the next step.
when i clik to go back it show the following errors:
* 1 entries inserted to table mtx381_bannerclient.
* 1 entries inserted to table mtx381_imgset_tplset_link.
* 3 entries inserted to table mtx381_groups.
* 2 entries inserted to table mtx381_groups_users_link.
* 55 entries inserted to table mtx381_group_permission.
* 29 entries inserted to table mtx381_tplfile.
* 29 entries inserted to table mtx381_tplsource.
* 12 entries inserted to table mtx381_newblocks.
* 12 entries inserted to table mtx381_block_module_link.
* Failed inserting 7 entries to table mtx381_configcategory.
* Failed inserting 34 entries to table mtx381_configoption.
* Failed inserting 1 entries to table mtx381_imgset.
* Failed inserting 7 entries to table mtx381_ranks.
* Failed inserting 17 entries to table mtx381_smiles.
* Failed inserting 3 entries to table mtx381_banner.
* Failed inserting 1 entries to table mtx381_tplset.
* Failed inserting 1 entries to table mtx381_modules.
* Failed inserting 1 entries to table mtx381_users.
* Failed inserting 12 entries to table mtx381_block_module_link.
* Failed inserting 93 entries to table mtx381_config.
Tried executing the sql command but get the following error:
as follows:
INSERT INTO configcategory VALUES (1, '_MD_AM_GENERAL', 0);
INSERT INTO configcategory VALUES (2, '_MD_AM_USERSETTINGS', 0);
INSERT INTO configcategory VALUES (3, '_MD_AM_METAFOOTER', 0);
INSERT INTO configcategory VALUES (4, '_MD_AM_CENSOR', 0);
INSERT INTO configcategory VALUES (5, '_MD_AM_SEARCH', 0);
INSERT INTO configcategory VALUES (6, '_MD_AM_MAILER', 0);
INSERT INTO configcategory VALUES (7, '_MD_AM_AUTHENTICATION', 0);
then get following error:
Error
SQL query:
INSERT INTO configcategory
VALUES ( 1, '_MD_AM_GENERAL', 0 ) ;
MySQL said: Documentation
#1146 - Table 'multix2334.configcategory' doesn't exist
i then appended the db prefix to the table but get the following error:
Error
SQL query:
INSERT INTO mtx381_configcategory
VALUES ( 1, '_MD_AM_GENERAL', 0 ) ;
MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
WHEN I CHECKED THE DATABASE THE TABLES AND THEIR ENTRIES ALREADY EXIST.
OF i CLICK NEXT AT THE INSTALLATION PAGE i GET A BLANK SCREEN
====
My Dev server info:
Checking your server configuration
Requirements
Server API apache2handler
Apache/2.2.4 (Win32) PHP/5.2.1
PHP version 5.2.1
MySQL extension 5.0.27
Session extension Success
PCRE extension Success
file_uploads ON
Recommended extensions
These extensions are not required for normal use, but may be necessary to exploit some specific features (like the multi-language or RSS support). Thus, it is recommended to have them installed.
Character encoding extension MBString
Character set conversion extension Iconv
XML parsing extension XML
Zlib Compression extension Zlib
Image functions extension GD bundled (2.0.28 compatible)
Image meta data (exif) extension None
