Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro
Author Message
john_mar
New Member
New Member


Joined: Nov 14, 2005
Posts: 15

PostPosted: Mon Jan 02, 2006 6:43 pm Reply with quote

Have installed Ravens7.6 bundle (7.6 +3.1 +Sent) PLUS I have Gallery2.0 and NuCalendar modules installed. Regressing back from a 7.9 with NSN2.0 install cos of security and nsn wasn't working for me.

I pretty much followed the install but copied over files and also SQL'ed certain tables over the new 7.6 database from the 7.9 database, including the stories table.... the 7.9 stories imported in ok...BUT...

Now when I submit news items, either as admin or thru submit news.... nothing seems to happen, news items just don't get into the stories table.

Searched around and this post seemed to have similiar issue.
Only registered users can see links on this board! Get registered or login!

Tried that stuff but no joy...

Set the error diplay to true and nothing displayed...
Only trying to post plain old text...no fancy HTML!

This is my stories table:

Code:
     


         sid         int(11)           No            
    catid            int(11)         No     0          
    aid               varchar(30)         No               
    title        varchar(80)         Yes     NULL     
    time           datetime         Yes     NULL          
    hometext     text            Yes     NULL          
    bodytext        text            No               
    comments        int(11)         Yes     0          
    counter        mediumint(8)    UNSIGNED    Yes     NULL          
    topic           int(3)            No     1          
    informant        varchar(20)         No               
    notes        text            No               
    ihome        int(1)            No     0          
    alanguage        varchar(30)         No               
    acomm        int(1)            No     0          
    haspoll        int(1)            No     0          
    pollID        int(10)         No     0          
    score        int(10)         No     0          
    ratings        int(10)         No     0          
    rating_ip        varchar(15)         Yes     0          
    associated        text            No             
     


Anyone got any ideas?

Update... Ahhh... just checked the SQL file I used to bring in the old stories from 7.9 and

Code:
-- 

-- Table structure for table `nuke_stories`
--

DROP TABLE IF EXISTS `nuke_stories`;
CREATE TABLE `nuke_stories` (


Looks like I might have knackered my stories table.

Can anyone confirm what a 7.6 table should look like and that this is my problem?


John Mar
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Mon Jan 02, 2006 6:58 pm Reply with quote

Look at the sql that comes with RavenNuke76(tm). That has the stories schema in it Smile
 
View user's profile Send private message
john_mar
PostPosted: Tue Jan 03, 2006 4:57 pm Reply with quote

Thanks Raven.

Was late last night and had to hit the sack and just thought of that when I switched off the light Rolling Eyes

Just sorted it. The tables do differ.

One extra field in the 7.9 version...
rating_ip varchar(15)
....and a couple of other fields are longer lengths

Just deleted the old table and cut the stories SQL from the SQL install file and ran it manually and now all sorted and working

many thanks raven

John Mar
 
Raven
PostPosted: Tue Jan 03, 2006 5:47 pm Reply with quote

RavensScripts
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v1.x Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©