1
Xavi_R
Re: Standardising URL formats - Help required
  • 2009/4/28 16:38

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20


Thanks very much for your input it has made my life alot easier. Saying that, I have had to start learning about PHP debugging - a completely new learning curve for me.

Xavi



2
Xavi_R
Re: Standardising URL formats - Help required
  • 2009/4/26 10:46

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20


Oh! Before anyone tells me to change my DNS provider, I am trying to avoid that as much as I can for personal reasons.



3
Xavi_R
Standardising URL formats - Help required
  • 2009/4/26 10:43

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20


Unfortunately my Domain Name Provider's web forwarding service is restrictive to say the least and I have found that the only way to get around this is to use a dynamic DNS service to help with my website redirection to allow me to host subdomains.

I then found I also have a problem with the XOOPS 2.3.3 CMS. The domain names I have used are fictitious as I still want the sites to remain priate until I have got them up and running. The setup is as follows:
Main Domain Name: http://paul.tandt.co.uk
Dynamc DNS Name: http://my.dns.pointer.org

Due to the restrictions on my Main Domain redirection. something like "http://paul.tandt.co.uk/themes/default/icons/favicon.ico" does not work however "http://my.dns.pointer.org/include/xoops.js" does work.

The result is that the opening page of the website and the home page once signed in have got little/no formatting although the Admin pages work fine. I have taken an extract from the sources of the opening page and the Admin page.

Extract from Opening Page

<!-- Rss -->
<link rel="alternate" type="application/rss+xml" title="" href="http://paul.tandt.co.uk/backend.php" />

<!-- Favicon -->
<link rel="shortcut icon" type="image/ico" href="http://paul.tandt.co.uk/themes/default/icons/favicon.ico" />
<link rel="icon" type="image/png" href="http://paul.tandt.co.uk/themes/default/icons/favicon.png" />
<!-- Sheet Css -->
<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="http://paul.tandt.co.uk/xoops.css" />
<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="http://paul.tandt.co.uk/themes/default/style.css" />

<!-- customized header contents -->
<meta http-equiv="Content-Script-Type" content="text/javascript" />

<meta http-equiv="Content-Style-Type" content="text/css" />
<script type="text/javascript" src="http://my.dns.pointer.org/include/xoops.js">
</script>
<link rel="stylesheet" href="http://my.dns.pointer.org/language/english/style.css" type="text/css" />


Extract from Administration Menu

<link rel="stylesheet" type="text/css" media="all" href="http://my.dns.pointer.org/xoops.css" /><link rel="stylesheet" type="text/css" media="all" href="http://my.dns.pointer.org/modules/system/class/gui/default/css/style.css" /><link rel="stylesheet" type="text/css" media="all" href="http://my.dns.pointer.org/modules/system/class/gui/default/css/en.css" /><link rel="stylesheet" type="text/css" media="all" href="http://my.dns.pointer.org/language/english/style.css" />
</head>
<body>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td bgcolor='#2a75c5' background='http://my.dns.pointer.org/modules/system/class/gui/default/images/xo-banner_bg.png'><a href='http://xoops.sourceforge.net/' rel='external'><img src='http://my.dns.pointer.org/modules/system/class/gui/default/images/xoops-logo.png' alt='Paul's Private Page' /></a></td>

<td align='right' bgcolor='#9F009F' background='http://my.dns.pointer.org/modules/system/class/gui/default/images/xo-banner_bg.png' colspan='2'><img src='http://my.dns.pointer.org/modules/system/class/gui/default/images/xoops23.gif' alt='' /></td>
</tr>
<tr>
<td align='left' colspan='3' class='bg5'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='1%'><img src='http://my.dns.pointer.org/modules/system/class/gui/default/images/hbar_left.gif' width='16' height='23' /></td>
<td class='hbar_middle'>
&nbsp;« <a href='http://my.dns.pointer.org/'>Home Page</a>

&nbsp;|&nbsp;<a href='http://my.dns.pointer.org/admin.php'>Control Panel Home</a>
&nbsp;|&nbsp;<strong>XOOPS »</strong>


I have looked at the theme page and taken an extract of this:
<!-- Rss -->
<link rel="alternate" type="application/rss+xml" title="" href="<{xoAppUrl backend.php}>" />

<!-- Favicon -->
<link rel="shortcut icon" type="image/ico" href="<{xoImgUrl icons/favicon.ico}>" />
<link rel="icon" type="image/png" href="<{xoImgUrl icons/favicon.png}>" />

What I would like to know is how can I change things like xoAppUrl, xoImgUrl and any other similar variables to use the value of XOOPS_URL set in the mainfile.config

Any help would be appreciated

Xavi



4
Xavi_R
Blocks not translating codes
  • 2008/7/26 17:59

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20


When I go into BLOCKS to edit them and if I enter something like:

[s-ize=medium][c-olor=000099][f-ont=Verdana]Test Message[/f-ont][/c-olor][/s-ize]

I have added the hypens(-) to stop this editor from translating them. They do not exist in my coding.

That is exactly how it displays when I open the relevant page, it does not translate these codes to show: Test Message.

I suspect a translation routine is not being called but I have no idea where to begin looking.

Any ideas????



5
Xavi_R
Re: How to fix Blank White Screen with following code
  • 2008/3/27 16:00

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20


You do not say what version of MySQL you are using. I am using version 6.0 and have had a similar problem. My knowledge of PHP is nil and as for SQL it is minimal but I have been soldiering away on my own to get this sorted.

If you look at the file "kernel\configitem"
Line 293 looks something like
$sql = 'SELECT * FROM '.$this->db->prefix('config');
.
and
.
Line 296 something like this
$sql .= ' ORDER BY conf_order ASC';

This sectio of code generates the query "SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC". If you run this query directly under the MySQL command line client then 0 records are returned. Take away the ORDER BY clause and it works but without the sort. The answer is use command line client to alter one of the indexes on the config table:

There are 2 lines you need to type in:
1) ALTER TABLE <prefix>_config DROP INDEX conf_mod_cat_id;
2) ALTER TABLE <prefix>_config ADD INDEX conf_mod_cat_id (conf_modid,conf_catid, conf_order);

Adding the extra field to this table should sort the issue. There is one other query you will need to alter and you will need to add a key to the relevant table.

In the file class\xoopsblock.php

Around line 437:
$sql = 'SELECT b.* FROM '.$db->prefix('newblocks').' b, '.$db->prefix('block_module_link').' m WHERE m.block_id=b.bid';

Change to:
$sql = 'SELECT b.* FROM '.$db->prefix('newblocks').' AS b USE INDEX (weight_bid), '.$db->prefix('block_module_link').' AS m WHERE m.block_id=b.bid';
The red bits are what has to be added.

Use the MySQLcommand line client to add an index on the newblocks table with:

ALTER TABLE <prefix>_newblocks ADD INDEX weight_bid (weight, bid);

The other queries you show have not given me any issues yet but that may be because I have corrected the original issues with these two solutions.



6
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?




7
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 <?phpinfo?>.

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" <Next><Next>
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.
<Next>

12) General questions (Entered the relevant data) <Next>
13) Confirm the following data <Next>
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 tohttp://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.
<Next>
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
<Next>
16) confirm database settings
Database Hostname localhost
Database Username root
Database Name tntweb
Table Prefix tnt
<Next>
17) check database
[GREEN] Connection to database server is OK.
[GREEN] Database tntweb exists and connectable.
Database connection is OK.
<Next>
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.
<Next>
19) Please choose your site admin's name and password.
Admin Name: WebExec
Admin Emal: theboys@............
.
.
<Next>
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.
<Next>
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
<HERE>

22) Blank Page (do a "View Source")
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>

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)




8
Xavi_R
Re: Blank page when finishing the installation
  • 2008/3/20 20:55

  • Xavi_R

  • Just popping in

  • Posts: 8

  • Since: 2008/3/20


I seem to be going around in circles looking at this forum for answers. I seem to be getting the blank page too. I am a newbie to this. I have edited eery php file and removed any extra lines after the ?> I did come across one file that I suspect is corrupt "theme_blocks.php". The last lines showing on the file are:

"} else {
$xoopsLogger->addBlock( $xobject->getVar('name'), true, $bcachetime );
$block['content'] = $template->fetch( $tplName, $cacheid );
}
return $block;
}


}"

There is no ?> at the end of the file. I added the delimiter myself to try it. I looked in the zip file that I downloaded and the "fault" shows up there.

I have checked permissions, recreated the database several times and re-run the install.

A view of the source from the blanks page is:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1"></HEAD>
<BODY></BODY></HTML>




TopTop



Login

Who's Online

219 user(s) are online (151 user(s) are browsing Support Forums)


Members: 0


Guests: 219


more...

Donat-O-Meter

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

Latest GitHub Commits