Installation problem

Welli

Posted on 21 Nov 2009, 17:08:53

Access: Member
Total Posts: 12
Joined: 2009-11-21

Hey guys'n'girls..

I am new to this script, however, i tried to download and install the version 3.2 (the 3.3. version didn't have any install.php file in it) but it didn't work. First it came with a server error, so i deleted the entire folder and uploaded it again.

Now, when i'm through with step 3 i get the following message:
Quote
Finalizing installation

Table 'news30_banned' already exists
Unquote

Afterwards if i try to call domain.com/n13news32/news/ I get this message:
Quote

Unknown column 'approved' in 'where clause'

Unquote.

I can get the "admin screen" to appear but i can't change any settings ore anything like that without getting an error. Furthermore the "News" section of the menu in the admin area is missing.

Can anyone out there please assist me ? Am im doing something wrong here ore?

Thanks in advance :flowers:

#1205

Last edited by Welli at 2009-11-21 17:47:03 Reason:

Chris

Posted on 21 Nov 2009, 19:14:57

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Hi Welli,

Thanks for bringing the missing install.php file to my attention, I've been moving things around recently and somehow a few files got left out of the archive. I've now re-added the install.php back into the download so if you download 3.3 again you should be able to install it normally.

If you're using the same database you previously tried to install the script on you'll need to manually remove the tables in the database that were created previously. This is why the installation fails.

You can either delete the database and re-create it again to wipe it. Manually go in and delete the tables using a program like phpMyAdmin.

Once the tables have been deleted try re-installing 3.3 again and it now should work.

#1206

Welli

Posted on 21 Nov 2009, 20:06:04

Access: Member
Total Posts: 12
Joined: 2009-11-21

Hey Chris,

Thank you for the reply! It worked when i deleted the files. However, i am not able to install the 3.3 version - only the 3.2 version will work.

I tried to update the version aswell after intalling the 3.2 but it just gives me an internal server error. Looks like i have to use the 3.2 version for now :ermm:

Anyway, once again thank you for the reply! Look forward to use your system.

#1207

Chris

Posted on 21 Nov 2009, 20:07:59

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

The server error is likely due to friendly URLs. Try deleting the .htaccess file, hopefully then the error should go away.

#1208

Welli

Posted on 21 Nov 2009, 20:25:17

Access: Member
Total Posts: 12
Joined: 2009-11-21

Worked like a charm! Thank you for the help :)

Only thing not working now is SE friendly urls.. Maybe i can get it to work myself :)

Quote:

Edit: It works now - however, when reading the full news story, the story isn't embedded into the design of my site, but shows on a empty page with only the story shown. The rest of my website is not showing. Why is that?

Once again, thanks!

#1209

Last edited by Welli at 2009-11-21 21:37:46 Reason:

Chris

Posted on 21 Nov 2009, 22:19:32

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

The .htaccess file looks like this

Code:


RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule .* /news/index.php [L]

If you move it to the main www directory of your site then change it to

Code:


RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule .* /index.php [L]

index.php is the page that you're including the script into. Then when you click the full story it should show how it's supposed to.

#1210

Welli

Posted on 22 Nov 2009, 11:22:17

Access: Member
Total Posts: 12
Joined: 2009-11-21

That worked - Thanks Christ!

Now - theres just one problem left (seems like i find a new problem once the old one is resolved :original:

) When you click to read the full story of a spcefic news you get direted to domain.com/news/2/0/test-news.html - the news is embedded to the design of the site, however all images files (Headers, menu images etc) are missing. The image files are linked to domain.com/news/2/0/header.jpg domain.com/news/2/0/arrow.gif etc. instead of the original images which are located on domain.com/arrow.gif domain.com/header.gif domain.com/images/back_butoon.gif an so forworth.

What am i doing wrong ?

#1211

Chris

Posted on 22 Nov 2009, 20:32:11

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

You need to edit your css file and give all the images absolute paths instead of relative.

For example

Code:


.testheader {
    background-image: url('images/test.png');
}

This would need to be changed to

Code:


.testheader {
    background-image: url('./images/test.png');
}

or

Code:


.testheader {
    background-image: url('http://domain.com/images/test.png');
}

#1214

Welli

Posted on 23 Nov 2009, 20:46:29

Access: Member
Total Posts: 12
Joined: 2009-11-21

That worked - Thanks!

Now - one more litle thing (and then i'll stop bugging you :new_smiley:

) When i click to read the full story and comes to domain.com/new/3/0/testnews.html , the rest of the text on my site (Text in the menu and so on) is changing font and size - why is that? Is there any easy way to fix this?

#1220

Chris

Posted on 24 Nov 2009, 03:13:04

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

If some styles are changing when you view the full story it means either the stylesheet hasn't been changed properly to the full path or possibly something else has been missed out.

Would it be possible for yo to link me to your site so I can see the problem for myself? might be easier for me to figure out exactly what's causing it.

#1223