Big problem after renaming htacces.txt to .htacces.

My profile pages and phpbbconnector configwindow show:

SQL errorDB function failed with error number 1146
Table 'nozems_nl_joomla.users' doesn't exist SQL=UPDATE users SET user_avatar_type='0', user_avatar='' WHERE user_id='13'
SQL =
UPDATE users SET user_avatar_type='0', user_avatar='' WHERE user_id='13'

My login doesn't redirect.

databases are integrated, joomla: jos_ prefix and phpbb: phpbb_ prefix. the sql error doesn't show 'nozems_nl_joomla.phpbb_users' therefore there is something wrong with phpbbconnector $table_prefix. the forum is in the joomla directory located under /forum. so i tried to set phpconnector to "forum" "/forum" and "./forum" but it still doesn't work.

I've renamed htaccess to the old name, but this didn't change anything. So i made a backup of the local test server (files and database), which does work, so everything is the same on the remote as it is on the working local server. except ofcourse the forum's and joomla's config.php. but still on the remote it won't work and on the local it does.

test server:
apache 1.3.33
php 4.3.10
mysql 4.1.9

remote server
apache 2.0.49(fedora)
php 4.3.10
mysql 3.23.58

Post edited by: bdacier, at: 2006/11/10 17:12

Is Joomla installed in the website root?

Here are 2 cases to help illustrate...

If
Joomla = "www.yoursite.com"
forum = "www.yoursite.com/forum"
then forum directory = "forum"

If
Joomla = "www.yoursite.com/joomla"
Forum = "www.yoursite.com/joomla/forum"
then forum directory = "joomla/forum"

Greg

yes it is, on the test site it works, therefore i think it might have something to do with apache on the remote. could htaccess have changed anythin that won't resolve back to normal if you rename .htaccess to htaccess.txt

if you want check dev.nozems.nl and dev.nozems.nl/forum

so i'm using forum in the config. i've also tried /forum and ./forum but either doesn't work

Post edited by: bdacier, at: 2006/11/10 19:24

Wanted to make a test account for you, but i get the same error so that's not possible. the weird thing is that i can login, so the login is making the correct querie. but phpconnector and the profiles aren't.

Post edited by: bdacier, at: 2006/11/10 19:31

What happens if you unpublish the connector?

It reads the table prefix from the config.php file for phpbb... so if it is not finding the config file it doesn't know the prefix...

Does your server have a $_SERVER variable?

Also what happens when you open the control panel?

Allright if i unpublish the profile page for the users is displayed correctly. but the configpage for phpbbconnector still gives the same error as i reported. It indeed would seem like phpbbconnector isn't finding the forum, however it is there in the right place as you can see. the prefix is entered correctly in the forum's config file.

I'm sorry but where would i find the $_SERVER isn't this in the config of apache?

Can i hardcode the prefix?

I think the document_root could be the prob. could htaccess have changed that?

Post edited by: bdacier, at: 2006/11/11 00:03

If you hardcode anything it should be the forum location... because if you hardcode the prefix then you will still get errors because it could not use functions from phpbb later on...

Greg

You could make a simple php file like

[code:1]<?php
echo $_SERVER ;
?>[/code:1]

Then run that php file and it will let you know if you have that variable... also think you can see it from System Info in the backend of Joomla (but not sure)

Greg