I recently moved my Xoops site to a new server using PHP 5.2.5 and MySql 5.0.45. Now when I try adding a new entry nothing happens, and when I try to modify an existing entry it gets deleted.

Any help much appreciated.

Regards
Terry.

Perhaps, the trouble is caused by SQL compatibility.
Turn debug on and check the result of SQL.

I can't see anything in the debug window, but I think other modules are overwriting the output from PiCal. If I look at the database with the MySql Query Browser all of the entries for events I have modified have disappeared (including all instances of recurring events) and none of the new entries show.

Regards
Terry

Anyway, you should get the result of SQL debug.

This is what I get when I try to add a new entry:


Queries core
SELECT * FROM x573b3_config WHERE (conf_modid = '1' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM x573b3_session WHERE sess_id = '38f3qu0l3kmp719hje0dp1nnn5'
( 0.000409)
SELECT * FROM x573b3_users u, x573b3_user_profile p WHERE u.uid = p.profileid AND uid = '6' LIMIT 0, 1
( 0.00021)
SELECT * FROM x573b3_modules WHERE dirname = 'piCal'
( 0.000217)
SELECT * FROM x573b3_config WHERE (conf_modid = '12') ORDER BY conf_order ASC
( 0.000214)
SELECT * FROM x573b3_config WHERE (conf_modid = '1' AND conf_catid = '3') ORDER BY conf_order ASC
( 0.000221)
SELECT * FROM x573b3_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'block_read' AND gperm_groupid IN (1))
( 0.000222)
SELECT DISTINCT i.instanceid, b.*, i.* FROM x573b3_block_instance i, x573b3_newblocks b, x573b3_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (50,48,72,9,8,215,204,157,149,148,145,144,86,74,47,206,153,17,10,216,188,208,147,207,163,203,90,130,5,3,2,1,52,202) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND ( (m.module_id=0 AND m.pageid=0) OR (m.module_id=12 AND m.pageid IN (0,0)) ) ORDER BY i.weight,i.instanceid
( 0.000254)
SELECT * FROM x573b3_xoopsnotifications WHERE (not_modid = '12' AND not_category = 'global' AND not_uid = '6')
( 0.000193)
SELECT * FROM x573b3_modules WHERE mid = 12
( 0.000181)
Total Number of Queries: 10 | Total SQL Generation Time: 0.002121

Queries module
SELECT * FROM x573b3_config WHERE (conf_modid = '1' AND conf_catid = '6') ORDER BY conf_order ASC
( 0.000199)
DELETE FROM x573b3_protector_access WHERE expire < UNIX_TIMESTAMP()
( 0.000261)
SELECT COUNT(*) FROM x573b3_protector_access WHERE ip='10.0.0.26' AND request_uri='/modules/piCal/index.php?smode=Daily&caldate=2007-12-29'
( 0.00033)
SELECT COUNT(*) FROM x573b3_protector_access WHERE ip='10.0.0.26'
( 0.000278)
INSERT INTO x573b3_protector_access SET ip='10.0.0.26',request_uri='/modules/piCal/index.php?smode=Daily&caldate=2007-12-29',expire=UNIX_TIMESTAMP()+'60'
( 0.00031)
SELECT mid FROM x573b3_modules WHERE dirname LIKE 'piCal'
( 0.000274)
SELECT conf_name,conf_value FROM x573b3_config WHERE conf_modid=12
( 0.000188)
SELECT groupid, name FROM x573b3_groups ORDER BY name ASC
( 0.000174)
SELECT * FROM x573b3_modules WHERE dirname = 'statistics'
( 0.000227)
SELECT * FROM x573b3_config WHERE (conf_modid = '47') ORDER BY conf_order ASC
( 0.00022)
select * from x573b3_stats_refer_blacklist
( 0.000176)
UPDATE x573b3_counter SET count=count+1 WHERE (type='total' AND var='hits') OR (var='MSIE' AND type='browser') OR (var='Windows' AND type='os')
( 0.000407)
SELECT year FROM x573b3_stats_year WHERE year='2007'
( 0.000302)
SELECT hour FROM x573b3_stats_hour WHERE (year='2007') AND (month='12') AND (date='29')
( 0.005143)
UPDATE x573b3_stats_year SET hits=hits+1 WHERE year='2007'
( 0.000271)
UPDATE x573b3_stats_month SET hits=hits+1 WHERE (year='2007') AND (month='12')
( 0.000254)
UPDATE x573b3_stats_date SET hits=hits+1 WHERE (year='2007') AND (month='12') AND (date='29')
( 0.000453)
UPDATE x573b3_stats_hour SET hits=hits+1 WHERE (year='2007') AND (month='12') AND (date='29') AND (hour='12')
( 0.004523)
SELECT id FROM x573b3_stats_ip WHERE ip='10.0.0.26' AND date>'2007122911'
( 0.015659)
UPDATE x573b3_stats_ip SET date='2007122912', hits=hits+1 WHERE id='27351'
( 0.000306)
DELETE FROM x573b3_stats_refer where date <= '2007122412'
( 0.020794)
select options from x573b3_newblocks where name='Top Referers' and dirname='statistics'
( 0.000168)
SELECT id FROM x573b3_stats_refer WHERE refer='www.auscps.com' AND referpath='/modules/piCal/index.php|smode=Daily&action=Edit&caldate=2007-12-29' AND date>'2007122911' and ip='10.0.0.26'
( 0.018399)
INSERT INTO x573b3_stats_refer (ip, refer, date, hits, referpath) VALUES ('10.0.0.26', 'www.auscps.com', '2007122912', '1', '/modules/piCal/index.php|smode=Daily&action=Edit&caldate=2007-12-29')
( 0.000302)
SELECT * FROM x573b3_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_groupid IN (1))
( 0.0002)
SELECT pi_title,pi_dirname AS dirname,pi_file AS file,pi_dotgif AS dotgif,pi_options AS options FROM x573b3_pical_plugins WHERE pi_type='daily' AND pi_enabled ORDER BY pi_weight
( 0.000205)
Total Number of Queries: 26 | Total SQL Generation Time: 0.070023

Queries block
SELECT * FROM x573b3_modules WHERE dirname = 'xcgal'
( 0.00021)
SELECT count(*) from x573b3_xcgal_pictures WHERE approved = 'YES'
( 0.000161)
SELECT count(*) from x573b3_xcgal_pictures WHERE approved = 'YES'
( 0.000156)
SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime FROM x573b3_xcgal_pictures WHERE randpos IN (1) AND approved = 'YES' ORDER BY RAND() LIMIT 5
( 0.00253)
SELECT * FROM x573b3_config WHERE (conf_modid = '11') ORDER BY conf_order ASC
( 0.000221)
SELECT * FROM x573b3_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC
( 0.000223)
SELECT * FROM x573b3_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_groupid IN (1))
( 0.00018)
SELECT * FROM x573b3_modules WHERE dirname = 'news'
( 0.000238)
SELECT cid, title FROM x573b3_weblinks_category WHERE pid='0' ORDER BY orders, cid
( 0.000211)
SELECT * FROM x573b3_modules WHERE dirname = 'edito'
( 0.000189)
SELECT * FROM x573b3_config WHERE (conf_modid = '45') ORDER BY conf_order ASC
( 0.000224)
SELECT Id_content, subject, groups FROM x573b3_edito WHERE offline = 1 AND contents_nomain = 1 ORDER BY subject ASC
( 0.000181)
SELECT * FROM x573b3_modules WHERE dirname = 'shoutbox'
( 0.000205)
SELECT * FROM x573b3_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
( 0.000194)
SELECT Id_content, subject, offline, groups, artimage, datesub, counter FROM x573b3_edito WHERE offline=1 ORDER BY subject ASC
( 0.000182)
SELECT COUNT(*) FROM x573b3_multimenu01 WHERE hide = 1
( 0.000188)
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM x573b3_multimenu01 WHERE hide = 1 ORDER BY weight ASC
( 0.000174)
SELECT * FROM x573b3_smiles
( 0.000194)
SELECT mid FROM x573b3_modules WHERE dirname LIKE 'piCal'
( 0.00019)
SELECT conf_name,conf_value FROM x573b3_config WHERE conf_modid=12
( 0.000174)
SELECT groupid, name FROM x573b3_groups ORDER BY name ASC
( 0.000185)
SELECT mid FROM x573b3_modules WHERE dirname LIKE 'piCal'
( 0.00018)
SELECT conf_name,conf_value FROM x573b3_config WHERE conf_modid=12
( 0.000172)
SELECT groupid, name FROM x573b3_groups ORDER BY name ASC
( 0.000163)
SELECT * FROM x573b3_modules WHERE dirname = 'pm'
( 0.000183)
SELECT COUNT(*) FROM x573b3_priv_msgs WHERE (read_msg = '0' AND to_userid = '6')
( 0.00019)
SELECT COUNT(*) FROM x573b3_online WHERE online_uid=6
( 0.000358)
UPDATE x573b3_online SET online_updated=1198891373, online_module = 12 WHERE online_uid = 6
( 0.00038)
SELECT * FROM x573b3_online
( 0.000255)
SELECT * FROM x573b3_modules WHERE isactive = '1'
( 0.000193)
SELECT country2,country FROM x573b3_iptoc WHERE IPFROM<=1123632838 AND IPTO>=1123632838
( 0.000164)
SELECT * FROM x573b3_modules WHERE isactive = '1'
( 0.000179)
SELECT country2,country FROM x573b3_iptoc WHERE IPFROM<=167772186 AND IPTO>=167772186
( 0.00016)
SELECT * FROM x573b3_modules WHERE isactive = '1'
( 0.000178)
SELECT country2,country FROM x573b3_iptoc WHERE IPFROM<=167772186 AND IPTO>=167772186
( 0.000211)
SELECT * FROM x573b3_modules WHERE isactive = '1'
( 0.000202)
SELECT country2,country FROM x573b3_iptoc WHERE IPFROM<=1073862566 AND IPTO>=1073862566
( 0.000175)
SELECT * FROM x573b3_modules WHERE isactive = '1'
( 0.000192)
SELECT country2,country FROM x573b3_iptoc WHERE IPFROM<=2098741144 AND IPTO>=2098741144
( 0.000176)
SELECT COUNT(*) FROM x573b3_online WHERE online_module = '12'
( 0.000287)
SELECT COUNT(*) FROM x573b3_users u, x573b3_user_profile p WHERE u.uid = p.profileid AND level > '0'
( 0.000173)
SELECT COUNT(*) FROM x573b3_users u, x573b3_user_profile p WHERE u.uid = p.profileid AND user_regdate >= '1198846800'
( 0.000159)
SELECT COUNT(*) FROM x573b3_users u, x573b3_user_profile p WHERE u.uid = p.profileid AND user_regdate >= '1198760400'
( 0.000158)
SELECT * FROM x573b3_users u, x573b3_user_profile p WHERE u.uid = p.profileid AND (level > '0') ORDER BY user_regdate DESC LIMIT 0, 1
( 0.000206)
SELECT year, hits from x573b3_stats_year
( 0.000311)
Total Number of Queries: 45 | Total SQL Generation Time: 0.011415

Blocks
Static Thumbnails: (5 Queries) No Cache
Custom Block: (0 Queries) No Cache
Main Menu: (7 Queries) No Cache
Shoutbox: (2 Queries) No Cache
Menu 2: (1 Queries) No Cache
multiMenu 01: (3 Queries) No Cache
Search: Cached (regenerates every 86400 seconds)
MiniCalendar (piCal): Cached (regenerates every 60 seconds)
Today's events (piCal): (3 Queries) No Cache
Coming Events (piCal): (3 Queries) No Cache
User Menu: (2 Queries) No Cache
Themes: (0 Queries) No Cache
Top Posters: Cached (regenerates every 300 seconds)
New Members: Cached (regenerates every 60 seconds)
Custom Block: Cached (regenerates every 86400 seconds)
Membership: (18 Queries) No Cache
Site Hits: (1 Queries) No Cache
Total: 17 blocks

Execution Time
XOOPS took 0.34167289733887 seconds to load.

Extra

Any red colored queries?

Quote:
This looks a SQLs after redirected.
There should be a SQL like

INSERT INTO (prefix)_pical(n)_events ...

Don't know if piCal supports wysiwyg editors, but I had similar problems using editors from the xoopseditor-package with modules not written by phppp on some of my local servers.
If you use an editor from this package try the standard DHTML-editor instead and/or remove the xoopseditor package...

There are no red entries.

I don

CBB?
I cannot understand what you mean.
Anyway, there is nothing I can do, before you point it.