Page 1 of 1
Cannot modify content (changes don't get saved, yet success is reported) 1.0.2
Posted: Mon Oct 09, 2006 5:30 pm
by Matt Jason H
As title really. Running 1.0.2.
I edit a page, save it, it says it's been modified successfully, but if i view the page on the site or try and modify it again, it hasn't saved the changes i made.
It was running fine until i upgraded to 1.0.1 a few weeks ago from quite an old version.
I had a problem with the reorder page permission not being written, so various buttons were missing on the modify pages list.
I used a fix Dee provided for this, which worked a treat and fixed the issue.
(see:
http://forum.cmsmadesimple.org/index.ph ... 977.0.html)
However, since that time i'm having problems.
I've tried upgrading from 1.0.2 -> 1.0.2 to see if it was an FTP transfer error (i did get a few warning/retrys) but it hasn't corrected the problem.
I'm at a loss of what i can do, short of making any changes directly to the database using MySQL queries, but i don't think my client would be happy with that solution!
Cheers for any help in advance,
Matt
Re: Cannot modify content (changes don't get saved, yet success is reported) 1.0
Posted: Thu Oct 12, 2006 8:44 am
by Matt Jason H
I've just finished checking all my permissions, database settings, MySQL settings.
I'm totally stumped, has anyone else experienced this?
Matt
Re: Cannot modify content (changes don't get saved, yet success is reported) 1.0
Posted: Thu Oct 12, 2006 9:33 am
by tsw
set debug mode on and check if there are any errors..
Re: Cannot modify content (changes don't get saved, yet success is reported) 1.0
Posted: Fri Oct 13, 2006 7:49 am
by Matt Jason H
I get this debug information after saving the page...
Code: Select all
Debug: (2E-05)
loading smarty
Debug: (0.008134)
loading adodb
Debug: (0.010783)
loading page functions
Debug: (0.016331)
loading content functions
Debug: (0.022089)
loading pageinfo functions
Debug: (0.023996)
loading translation functions
Debug: (0.025223)
loading events functions
Debug: (0.028916)
loading template functions
Debug: (0.033462)
loading gcb functions
Debug: (0.037477)
loading module class
Debug: (0.050571)
loading bookmark functions
Debug: (0.05327)
loading content class
Debug: (0.069522)
loading user functions
Debug: (0.073683)
loading group functions
Debug: (0.077299)
loading stylesheet functions
Debug: (0.080531)
loading user tags functions
Debug: (0.082184)
done loading files
Debug: (0.110775)
<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.116595)
<br>
(mysql): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.176359)
<br>
(mysql): SELECT * FROM cms_modules ORDER BY module_name<br>
Error (0): <br>
Debug display of 'End of include':(0.270805)
Debug: (0.271062)
Session found. Moving on...
Debug: (0.271217)
Session found. Moving on...
Debug: (0.296557)
Session found. Moving on...
Debug: (0.297442)
<br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '2'<br>
Error (0): <br>
Debug: (0.297914)
Session found. Moving on...
Debug: (0.302005)
Session found. Moving on...
Debug: (0.311697)
<br>
(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '2'<br>
Error (0): <br>
Debug: (0.331473)
<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '2'<br>
Error (0): <br>
Debug: (0.332923)
<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = 2<br>
Error (0): <br>
Debug: (0.335849)
<br>
(mysql): SELECT content_id FROM cms_additional_users WHERE user_id = '2'<br>
Error (0): <br>
Debug: (0.355056)
<br>
(mysql): SELECT bookmark_id, user_id, title, url FROM cms_admin_bookmarks WHERE user_id = '2' ORDER BY title<br>
Error (0): <br>
Debug display of 'Start Loading Hierarchy Manager':(0.356902)
Debug display of 'Load Content Operations':(0.357049)
Debug display of 'End Load Content Operations':(0.35779)
Debug display of 'starting tree':(0.357918)
Debug: (0.367327)
<br>
(mysql): SELECT id_hierarchy FROM cms_content ORDER BY hierarchy<br>
Error (0): <br>
Debug display of 'Start Loading Children into Tree':(0.368007)
Debug display of 'End Loading Children into Tree':(0.369773)
Debug: (0.369896)
Serializing...
Debug: (0.373307)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy<br>
Error (0): <br>
Debug display of 'ending tree':(0.381552)
Debug display of 'End Loading Hierarchy Manager':(0.381717)
Debug: (0.394816)
Session found. Moving on...
Debug: (0.395004)
Session found. Moving on...
Debug: (0.401865)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = 1 ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.40706)
<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '1'<br>
Error (0): <br>
Debug: (0.409236)
<br>
(mysql): SELECT username, password, active, first_name, last_name, admin_access, email FROM cms_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.421825)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = 12 ORDER BY hierarchy<br>
Error (0): <br>
Debug: (0.428183)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = 6 ORDER BY hierarchy<br>
Error (0): <br>
Re: Cannot modify content (changes don't get saved, yet success is reported) 1.0
Posted: Fri Oct 13, 2006 8:05 am
by tsw
hmm, editcontent doesnt show any debug log

that log is from the view pages code..
can you do a new clean install and check that your db and the new clean db are similar.