1
Xavi_R
Complete information on a new installation resulting in a blank homepage
  • 2008/3/21 23:57

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20



Information from xoopsinfo.php

Website URL: http://localhost
XOOPS Version: XOOPS 2.0.18.1
XOOPS Theme:
XOOPS Template Set:
Module Name/Version:
PHP Version: 5.2.5
MySQL Version: 6.0.3-alpha-community
Web Server Software: Apache/2.2.8 (Win32) PHP/5.2.5
Operating System: Windows XP Professional
Theme you are using: Not selected a theme yet, I assume it is default
Custom template: (Yes/No) No
PHP Debug Messages: Cannot access debug info
MySQL Debug Messages: Cannot access debug info
Smarty Debug Messages: Cannot access debug info

A full description of the issue:
I installed XOOPS on a clean site. I had to modify the file "mysql.structure.sql" as the statement "TYPE=MyISAM" had to be changed to "ENGINE=MyISAM" as the "TYPE=" syntax is not supported in MySQL v.6.
I ran the installation and received green lights all the way. I supplied the Admin username and password and email settings. When I clicked the link to view my site I got the blank page. I cannot get any information up for debug information and I have tried various suggestions from the forum. I have shown the steps I took to intall the system with results and included .ini files for PHP, MySQL and the conf file for Apache. If I knew how, I would attach a .pdf file showing the results from .

1) Downloaded xoops-2.0.18.1.zip
2) Extracted the zip file to the server root "F:\HTDOCS"
3) Moved the contents of "F:\HTDOCS\xoops-2.0.18.1\htdocs\" to "F:\HTDOCS\"
4) Installed and run checksum.php the result was:
There are 623 files checked.
Please remove the file ./checksum.md5 and checksum.php as soon as possible.
5) Edit "F:\HTDOCS\install\sql\mysql.structure.sql"
6) Global replace "TYPE=MyISAM" with "ENGINE=MyISAM"
7) Use MySQL command line to create database "tntweb"
8) Edit each file that ends in .php, .tpl, .html, .js or .css to remove any extraneous blank lines from the end of the file (I have read about these. I did notice that "theme_blocks.php" did not have a closing "?>" so I added this.
9) Backup the site.
10) Use browser to access "http://localhost/install/index.php"
Result: "Welcome to the Install Wizard for XOOPS"
11) Checking file and directory permissions:
[GREEN] Directory uploads/ is writable.
[GREEN] Directory cache/ is writable.
[GREEN] Directory templates_c/ is writable.
[GREEN] File mainfile.php is writable.


12) General questions (Entered the relevant data)
13) Confirm the following data
14) Saving configuration data:
[GREEN] File ../mainfile.php overwritten by ../mainfile.dist.php.
[GREEN] Constant XOOPS_ROOT_PATH written to F:/HTDOCS.
[GREEN] Constant XOOPS_URL written to http://localhost.
[GREEN] Constant XOOPS_DB_TYPE written to mysql.
[GREEN] Constant XOOPS_DB_PREFIX written to tnt.
[GREEN] Constant XOOPS_DB_HOST written to localhost.
[GREEN] Constant XOOPS_DB_USER written to root.
[GREEN] Constant XOOPS_DB_PASS written to 28092005.
[GREEN] Constant XOOPS_DB_NAME written to tntweb.
[GREEN] Constant XOOPS_DB_PCONNECT written to 0.
[GREEN] Constant XOOPS_GROUP_ADMIN written to 1.
[GREEN] Constant XOOPS_GROUP_USERS written to 2.
[GREEN] Constant XOOPS_GROUP_ANONYMOUS written to 3.
[GREEN] Constant XOOPS_CHECK_PATH written to 1.

15) check path URL
[GREEN] Physical path is correct.
[GREEN] Virtual path is a valid URL.
The server path to your XOOPS root directory: F:/HTDOCS
URL to your XOOPS root directory: http://localhost

16) confirm database settings
Database Hostname localhost
Database Username root
Database Name tntweb
Table Prefix tnt

17) check database
[GREEN] Connection to database server is OK.
[GREEN] Database tntweb exists and connectable.
Database connection is OK.

18)
[GREEN] Table tnt_avatar created.
[GREEN] Table tnt_avatar_user_link created.
[GREEN] Table tnt_banner created.
[GREEN] Table tnt_bannerclient created.
[GREEN] Table tnt_bannerfinish created.
[GREEN] Table tnt_block_module_link created.
[GREEN] Table tnt_xoopscomments created.
[GREEN] Table tnt_xoopsnotifications created.
[GREEN] Table tnt_config created.
[GREEN] Table tnt_configcategory created.
[GREEN] Table tnt_configoption created.
[GREEN] Table tnt_groups created.
[GREEN] Table tnt_group_permission created.
[GREEN] Table tnt_groups_users_link created.
[GREEN] Table tnt_image created.
[GREEN] Table tnt_imagebody created.
[GREEN] Table tnt_imagecategory created.
[GREEN] Table tnt_imgset created.
[GREEN] Table tnt_imgset_tplset_link created.
[GREEN] Table tnt_imgsetimg created.
[GREEN] Table tnt_modules created.
[GREEN] Table tnt_newblocks created.
[GREEN] Table tnt_online created.
[GREEN] Table tnt_priv_msgs created.
[GREEN] Table tnt_ranks created.
[GREEN] Table tnt_session created.
[GREEN] Table tnt_smiles created.
[GREEN] Table tnt_tplset created.
[GREEN] Table tnt_tplfile created.
[GREEN] Table tnt_tplsource created.
[GREEN] Table tnt_users created.
Database tables created.

19) Please choose your site admin's name and password.
Admin Name: WebExec
Admin Emal: theboys@............
.
.

20) insert data
[GREEN] 1 entries inserted to table tnt_bannerclient.
[GREEN] 7 entries inserted to table tnt_configcategory.
[GREEN] 30 entries inserted to table tnt_configoption.
[GREEN] 1 entries inserted to table tnt_imgset.
[GREEN] 1 entries inserted to table tnt_imgset_tplset_link.
[GREEN] 7 entries inserted to table tnt_ranks.
[GREEN] 17 entries inserted to table tnt_smiles.
[GREEN] 3 entries inserted to table tnt_groups.
[GREEN] 2 entries inserted to table tnt_groups_users_link.
[GREEN] 55 entries inserted to table tnt_group_permission.
[GREEN] 3 entries inserted to table tnt_banner.
[GREEN] 1 entries inserted to table tnt_tplset.
[GREEN] 1 entries inserted to table tnt_modules.
[GREEN] 27 entries inserted to table tnt_tplfile.
[GREEN] 27 entries inserted to table tnt_tplsource.
[GREEN] 12 entries inserted to table tnt_newblocks.
[GREEN] 1 entries inserted to table tnt_users.
[GREEN] 12 entries inserted to table tnt_block_module_link.
[GREEN] 91 entries inserted to table tnt_config.

[GREEN] Constant XOOPS_GROUP_ADMIN written to 1.
[GREEN] Constant XOOPS_GROUP_USERS written to 2.
[GREEN] Constant XOOPS_GROUP_ANONYMOUS written to 3.

21) Installation Complete
Your site
Click HERE to see the home page of your site.

Way to use
Visit XOOPS Project Documents

Support
Visit The XOOPS Project


22) Blank Page (do a "View Source")





23) Run XOOPSinfo.php
Website URL: http://localhost
XOOPS Version: XOOPS 2.0.18.1
XOOPS Theme:
XOOPS Template Set:
PHP Version: 5.2.5
MySQL Version: 6.0.3-alpha-community
Server Software: Apache/2.2.8 (Win32) PHP/5.2.5
User's Browser: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR

2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2; .NET CLR 3.0.04506.648; MSN Optimized;GB; MSN

Optimized;GB)


2
Xavi_R
Re: Complete information on a new installation resulting in a blank homepage
  • 2008/3/22 13:36

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20



I hacked the "logger.php" file to write the errors to a file and this is the result:
I have no idea where to do next.

File: include\common.php Line: 171
Error Info: 8 - Undefined index: gzip_compression

File: include\common.php Line: 179
Error Info: 8 - Undefined index: debug_mode

File: include\common.php Line: 179
Error Info: 8 - Undefined index: debug_mode

File: class\xoopssecurity.php Line: 207
Error Info: 8 - Undefined index: enable_badips

File: include\common.php Line: 198
Error Info: 8 - Undefined index: language

File: include\common.php Line: 245
Error Info: 8 - Undefined index: use_ssl

File: include\common.php Line: 247
Error Info: 8 - Undefined index: use_mysession

File: include\common.php Line: 260
Error Info: 8 - Undefined index: use_mysession

File: include\common.php Line: 283
Error Info: 8 - Undefined index: closesite

File: header.php Line: 39
Error Info: 8 - Undefined index: theme_set

File: header.php Line: 39
Error Info: 8 - Undefined index: theme_set

I have found a PHP Debug Utility and having no knowledge of the command/coding structure I went through step by step. I have slicght idea where the problem lays. The file CONFIGITEM.PHP in the function getObjects at around line 300 looks like this:
$result = $this->db->query($sql, $limit, $start);
if (!$result) {
return false;
}
while ($myrow = $this->db->fetchArray($result)) {
$config = new XoopsConfigItem();
$config->assignVars($myrow);
if (!$id_as_key) {
$ret[] =& $config;
} else {
$ret[$myrow['conf_id']] =& $config;
}
unset($config);
}
return $ret;

After the query, the variable $result = 17
On entering the WHILE loop the variable has the value NULL.
The function fetchArray is called once with the $result = 17.
The execution does not enter the WHILE loop at all and now the value $myrow = FALSE.
What puzzles me is that there are 31 entries that match the SQL Criteria for the query
SELECT * FROM tnt_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
Any ideas why only 17 records are returned?


Login

Who's Online

354 user(s) are online (307 user(s) are browsing Support Forums)


Members: 0


Guests: 354


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits