Cannot modify content (changes don't get saved, yet success is reported) 1.0.2

[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

[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

[tsw]

set debug mode on and check if there are any errors..

[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>

[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.