| Author |
 Topic  |
|
StephenD
Senior Member
Australia
1044 Posts |
 Posted - 23 April 2005 : 06:04:04
|
I've got a clean snitz install with the Portal Mod 1.01 . When I go to edit an article the existing body content does not show and appears to be deleted. The set category is correct but the author field is also blank. I've tried running the dbs again.
Anyone know what could cause the body text to disappear? |
Edited by - StephenD on 24 April 2005 23:05:36 |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 24 April 2005 : 23:02:51
|
A bit more information:
MS SQL DB. Snitz 3.4.05
IE6, Maxthon or Mozilla.
The admin_cms_content.asp is identical to one on one of my working sites.
I just tried it on another blank DB and clean snitz install and get the same result. Is there something I am missing here? You can add new content ok and it shows up fine in the db and portal page. But when you go to edit the content it is deleted from view. If you then hit submit then it is gone for good. |
 |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 25 April 2005 : 17:49:38
|
| OK, I've now tried it on a clean Snitz 3.4.04 and 3.4.03 with the same results. Can anyone point me in the right direction please. |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 25 April 2005 : 22:56:59
|
| Something else I've noticed - the Article Posted/Created date does not show on the front page. The edited date shows ok. Any chance this could be linked to my above problem. |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 26 April 2005 : 19:57:10
|
Getting desperate now. How can I check if the admin_cms_content is actually pulling all the data from the DB for display?
Another date issue (possibly related) is I've noticed the following in the Members Table:
Member Name Title Posts Last Post Member Since Last Visit
Julian Talbot CEO 1 26/04/2005 17/04/2005 24/04/2005
Note the discrepancy between the Last Post date and Last Visit date? |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 27 April 2005 : 01:47:48
|
| I see the same problem now with the Links Manager Mod. When editing a link the body text is not visible but has been deleted. I open the DB in Enterprise Manager and the db is ok. The dbs files ran ok. The data looks OK. Could it be 2 different issues or the one? Anyone able to help? |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 27 April 2005 : 08:09:09
|
| Anybody? |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 27 April 2005 : 18:06:22
|
| OK, I've allocated about 3hrs this morning to beating this bluddy error. Anyone got any idea what could be going wrong with my db(s). |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 28 April 2005 : 16:51:10
|
| Up to top... |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 28 April 2005 : 17:27:33
|
OK, on my test db if I change the CONT_BODY column in the CMS_CONTENT table from 'text' to 'nvarchar' the admin_cms_content page works as it should, the content body shows, the author shows and the posted date now shows on the front portal page.
Does this mean the dbs code was not set for MS SQL? Here is the dbs_script:David's Portal Mod
[DROP]
CMS_CATEGORY
[END]
[DROP]
CMS_CONTENT
[END]
[CREATE]
CMS_CATEGORY
CAT_ID
CAT_TITLE#varchar(20)#NULL#
CAT_ISLEFT#smallint#NULL#0
CAT_ORDER#int#NULL#
[END]
[CREATE]
CMS_CONTENT
CONT_ID
CAT_ID#int#NULL#
CONT_TITLE#varchar(100)#NULL#
CONT_SUMMARY#text#NULL#
CONT_BODY#text#NULL#
CONT_POSTEDBY#int#NULL#
CONT_AUTHOR#int#NULL#
CONT_DATE#varchar(14)#NULL#
CONT_LAST_EDIT#varchar(14)#NULL#
CONT_STATUS#smallint#NULL#0
[END]
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('strCMSLeftNavWidth','150')
(C_VARIABLE,C_VALUE)#('strCMSLeftNavDisplay','5')
(C_VARIABLE,C_VALUE)#('strCMSLeftNavItems','1')
(C_VARIABLE,C_VALUE)#('strCMSRightNavWidth','150')
(C_VARIABLE,C_VALUE)#('strCMSRightNavDisplay','5')
(C_VARIABLE,C_VALUE)#('strCMSRightNavItems','1')
(C_VARIABLE,C_VALUE)#('strCMSEnableSearch','1')
(C_VARIABLE,C_VALUE)#('strCMSDefaultCID','0')
(C_VARIABLE,C_VALUE)#('strCMSPageTitle','Portal')
(C_VARIABLE,C_VALUE)#('strCMSTitleDisplay','1')
(C_VARIABLE,C_VALUE)#('strCMSEnableForumSearch','1')
(C_VARIABLE,C_VALUE)#('strCMSEnableGoogleSearch','1')
(C_VARIABLE,C_VALUE)#('strCMSEnableActiveTopics','1')
(C_VARIABLE,C_VALUE)#('strCMSActiveTopicsItems','5')
[END]
???
|
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 28 April 2005 : 18:02:13
|
Stephen,
Look at this for the DB side of things: Database Setup Tool
I am not sure what is happening with your issue, but have a feeling it is something to do with the way people are posting. If a user doesn't logon to post, then they are not seen as being there.
So basically a user visits the site, and doesn't login, but decides to reply to a post and they hit the reply button, but are only given the enter your Username and Password, this doen't register them as logining in to your site, but it knows who they are after they enter their details and accepts the post. That is how you could get the Last Post date after the Last Visit date.
I have had it happen on my system and it was strange at first. I even sent out users warning e-mails from the Inactive Users mod and they said look at this post and you will see, then I asked them how they posted and it was from the reply button, with out logining on. I hope that makes some sort of sense.
|
Cheers,
David Greening |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 28 April 2005 : 18:08:37
|
Thanks David, although the online test forum is set to 'Private' so login is required to get in first. I only noticed it once more and seems to have settled down now though.
Something funny going on with my DB. I thought it might be date format. I'm really at the end of the road and may have to scram the portal mod if I can't get the editing function working. |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 28 April 2005 : 19:31:53
|
Any other MS SQL Portal Mod users out there have any problems with the cont_body field?
Changing the field attributes to varchar is not an option. |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 29 April 2005 : 21:29:37
|
Spent some time last night with V8Impact (thank you!) trying to resolve this issue. Could not determine cause. Cont_body data is being saved correctly in the db and displays ok when you add new content. It is only when you go to edit the content that the admin_cms_content does not retrieve the cont_body text for display.
Here are text links to my admin_cms_content and my inc_func_posting files.
I can arrange a login too. Anybody got any ideas please.... |
Edited by - StephenD on 29 April 2005 21:31:06 |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 29 April 2005 : 23:23:41
|
Stephen, send me details as I have just downloaded the Portal Mod and put it on a test site and have an idea on what your issue is and would like to confirm before saying it public.
Are you in Melbourne? If so a contact number would be good as well.
|
Cheers,
David Greening |
Edited by - Classicmotorcycling on 29 April 2005 23:25:48 |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 29 April 2005 : 23:51:32
|
| I'm in Perth David, I've emailed you a login. |
|
|
|
Topic |
|
Topic Locked
