Hi,
I am not able to add category in xoopsfaq module.

it is working in the test system but not in my live server(its hosted at GoDaddy.com). basically the insert statements are missing (find the sqls on debug mode).

Anybody has any idea on this?

Queries from local system:
---------------------------

All errors (0) queries (12) blocks (0) extra (0) timers (3)
Queries
SET NAMES 'utf8'
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 = '775e245f94fecb468bb76593a8757a99'
SELECT * FROM xoops_users WHERE uid = '1'
SELECT * FROM xoops_modules WHERE dirname = 'xoopsfaq'
SELECT * FROM xoops_config WHERE (conf_modid = '17') ORDER BY conf_order ASC
INSERT INTO xoops_xoopsfaq_categories (category_id, category_title, category_order) VALUES (0, 'test1', 4)
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 1, 1
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 1, 1
Total: 12 queries

Queries from production system
-----------------------------
All errors (0) queries (8) blocks (0) extra (0) timers (3)
Errors
Queries
SET NAMES 'utf8'
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 = 'a8m9ob5pprnocr9g6vgb8d2uq3'
SELECT * FROM xoops__users WHERE uid = '1'
SELECT * FROM xoops__modules WHERE dirname = 'xoopsfaq'
SELECT * FROM xoops__config WHERE (conf_modid = '17') ORDER BY conf_order ASC
SELECT * FROM xoops__group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT c.category_id, c.category_title, c.category_order, COUNT(f.category_id) FROM xoops__xoopsfaq_categories c LEFT JOIN xoops__xoopsfaq_contents f ON f.category_id=c.category_id GROUP BY c.category_id ORDER BY c.category_order ASC
Total: 8 queries
Blocks
Total: 0 blocks
Extra
Timers
XOOPS took 0.183 seconds to load.
XOOPS Boot took 0.092 seconds to load.
Module init took 0.091 seconds to load.



Deepak

Are your module and group permissions set right on the production system?

which php versions running local and online?

Production : PHP Version 5.2.5
Test : PHP Version 5.0.0RC2

Hi Ghia,

I have found a similar problem with myalbum module as as well, when I tried to update the global permission. its not setting any the group permission for registered users.

SELECT * FROM xoops__group_permission WHERE (gperm_name = 'myalbum_global' AND gperm_groupid = '2')

returns zero records ( where Group 2 is 'registered users')

Not sure what is the issue.

Thanks in advance.

Deepak

Is the collation the same for all tables in your database?
Is there a 'module_read' for the module id (in gperm_itemid) for the registred users group (2)?
Is there a 'module_admin' for the module id (in gperm_itemid) for you (the webmasters group)?

Yes I do have a record for module_read in both database (live & test)

SELECT * FROM xoops_group_permission
where gperm_name = 'module_read'
and gperm_itemid = 9

returns 3 record (for all group, 1= webmaster, 2 regsitered, 3= anonym)
----------------------------
but no record for module_admin for group 2

SELECT * FROM xoops__group_permission
where gperm_name = 'module_admin'
and gperm_itemid = 9

return only one record for gperm_groupid = 1
------------------------------

sorry I am new to this development area. How do i check the collation of my table?


Thanks
Deepak

The module group permissions seems correct.
Quote:In phpMyAdmin look at the column collation in the structure of your tables (one by one). It should be blank for numeric fields or having something like eg latin1_swedish_ci or utf8_general_ci for the text fields.

Thanks Ghia,

I will check that in some time and let you know..

i also noticed, when you update the Group permision i get the following message:
-----------------------------
Permissions have been changed successfully
If the page does not automatically reload, please click here

All errors (1) queries (17) blocks (0) extra (0) timers (3)
Errors
Notice: Undefined variable: HTTP_POST_VARS in file /modules/myalbum/admin/mygroupperm.php line 38
--------------------------

Deepak

Replace $HTTP_POST_VARS (which is deprecated) by $_POST .
Is your myalbum so old or not the latest version?