XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / How to fix Blank White Screen with following code
Register
1
b_ee_z
How to fix Blank White Screen with following code

  • 2008/3/27 6:19

  • b_ee_z

  • Just popping in

  • Posts: 4

  • Since: 2008/3/27


*does anyone know how to fix this*?



SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '34c7540ab6d106a7a11bcd0e09d2ab9a'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT * FROM xoops_configcategory
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
2
b_ee_z
Re: How to fix Blank White Screen with following code

  • 2008/3/27 6:49

  • b_ee_z

  • Just popping in

  • Posts: 4

  • Since: 2008/3/27


any kind of help would be appreciated
3
mawi27
Re: How to fix Blank White Screen with following code

  • 2008/3/27 7:07

  • mawi27

  • Friend of XOOPS

  • Posts: 103

  • Since: 2006/1/1 1


hi b_ee_z,

there is nothing to fix with the SQL Statements. These are the normal queries, when you open the system module.

Maybe you can find some help for your problem in this thread

marco
--
Match Dart!
Darts Ranking, News, Videos, Forum and more
4
b_ee_z
Re: How to fix Blank White Screen with following code

  • 2008/3/27 13:53

  • b_ee_z

  • Just popping in

  • Posts: 4

  • Since: 2008/3/27


thks ill take a look
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 _config DROP INDEX conf_mod_cat_id;
2) ALTER TABLE _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 _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.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

356 user(s) are online (293 user(s) are browsing Support Forums)

Members: 0

Guests: 356

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