1

Topic: Base URL

I am having problem changing things on the forum as the administrator and get the following  warning

Bad HTTP_REFERER. If you have moved these forums from one location to another or switched domains, you need to update the Base URL manually in the database (look for o_base_url in the config table) and then clear the cache by deleting all .php files in the /cache directory.

Can anyone tell me how to get into the database to changfe it manually?
yours in anticipation
Huey

Utrinque Paratus

2 (edited by SuperMAG 2008-04-03 18:02)

Re: Base URL

Huey wrote:

I am having problem changing things on the forum as the administrator and get the following  warning

Bad HTTP_REFERER. If you have moved these forums from one location to another or switched domains, you need to update the Base URL manually in the database (look for o_base_url in the config table) and then clear the cache by deleting all .php files in the /cache directory.

Can anyone tell me how to get into the database to changfe it manually?
yours in anticipation
Huey

wow that was exat thing that happened to me once ...

i think the solution is to go and edit config.php and there will be base url .. just change it ...

i am not sure about that ... so let some one else reply first

MyFootballCafe.com  is Now Online!

3

Re: Base URL

Where do I find the config table?

Utrinque Paratus

4

Re: Base URL

In the database. big_smile [your-db-prefix]config. It's the o_base_url setting.

5

Re: Base URL

Cheers MattI'll try and find it?

Utrinque Paratus

6

Re: Base URL

Cant find 0_base_url in config?

see below

Server: localhost   Database: forums   Table: config 
  Structure   Browse   SQL   Search   Insert   Export   Operations   Empty   Drop   




Showing rows 0 - 29 (70 total, Query took 0.0004 sec) 
SQL query:
SELECT *
FROM `config`
LIMIT 0 , 30 
[Edit] [Explain SQL] [Create PHP Code] [Refresh]


               row(s) starting from record # 
in  horizontal horizontal (rotated headers) vertical mode and repeat headers after  cells                                       
Page number: 1 2 3 

          Sort by key:  PRIMARY (Ascending) PRIMARY (Descending) None   
           conf_name conf_value
      o_cur_version 1.2.16
      o_board_title 1 Para Reunion Club Forum Welcomes You
      o_board_desc keep in touch with your old mates and make new one...
      o_server_timezone 0
      o_time_format H:i:s
      o_date_format Y-m-d
      o_timeout_visit 1200
      o_timeout_online 1000
      o_redirect_delay 1
      o_show_version 0
      o_show_user_info 1
      o_show_post_count 1
      o_smilies 1
      o_smilies_sig 1
      o_make_links 1
      o_default_lang English
      o_default_style Sulfur
      o_default_user_group 4
      o_topic_review 15
      o_disp_topics_default 30
      o_disp_posts_default 25
      o_indent_num_spaces 4
      o_quickpost 1
      o_users_online 1
      o_censoring 0
      o_ranks 1
      o_show_dot 1
      o_quickjump 1
      o_gzip 0
      o_additional_navlinks 2=<a href="http://www.1parareunionclub.com">Club W...
   Check All  /  Uncheck All   With selected:       


               row(s) starting from record # 
in  horizontal horizontal (rotated headers) vertical mode and repeat headers after  cells                                       
Page number: 1 2 3 

--------------------------------------------------------------------------------
Insert new row   Print view    Print view (with full texts)     Export


Bookmark this SQL query
Label:           
Let every user access this bookmark

Utrinque Paratus

Re: Base URL

There are more than 30 entries in the config table. Set the limit higher.

8

Re: Base URL

Thank U Elbeko I managed to change that but now cant find:-

clear the cache by deleting all .php files in the /cache directory.

Utrinque Paratus

9

Re: Base URL

It still reverts to the original URL? Im lost!

Utrinque Paratus

Re: Base URL

That's physically impossible if you updated the value in the database and then removed the .php files in the cache directory. wink

11

Re: Base URL

Cheers Smarty
I am not sure where the cache is. The only one I can search has nothing to remove?
Server: localhost   Database: forums   Table: search_cache 
  Structure   Browse   SQL   Search   Insert   Export   Operations   Empty   Drop   



        Field  Type Collation Attributes Null Default Extra Action
   id  int(10)    UNSIGNED No  0               
   ident  varchar(200) latin1_swedish_ci   No                 
   search_data  text latin1_swedish_ci   Yes  NULL               
Check All  /  Uncheck All     With selected:           



--------------------------------------------------------------------------------
Print view    Relation view    Propose table structure

     Add  field(s) At End of Table At Beginning of Table After id ident search_data 

--------------------------------------------------------------------------------
     Indexes:   
Keyname Type Cardinality Action Field
PRIMARY  PRIMARY  1       id 
search_cache_ident_idx  INDEX  None       ident  8 
Create an index on  columns   
   Space usage:   
Type Usage
Data 2,464 Bytes
Index 3,072 Bytes
Overhead 2,304 Bytes
Effective 3,232 Bytes
Total 5,536 Bytes
Optimize table 
   Row Statistics:   
Statements Value
Format dynamic 
Collation latin1_swedish_ci 
Rows 1 
Row length ø 160 
Row size  ø 5,536 Bytes 
Creation Dec 11, 2007 at 09:36 AM 
Last update Mar 30, 2008 at 09:40 PM 
Last check Dec 11, 2007 at 09:36 AM 


--------------------------------------------------------------------------------

Run SQL query/queries on database forums      Fields: 
SELECT * FROM `search_cache` WHERE 1     id ident search_data 
Show this query here again   

Or Location of the text file:   
Location of the text file:   
   (Max: 2,048MB)
 
  Compression:
     Autodetect   None   "gzipped"   
Character set of the file:   armscii8 ascii big5 binary cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8 


Bookmark this SQL query:
Bookmark options: 
  Label:
  Let every user access this bookmark 
 
           

Insert data from a text file into the table

Server: localhost   Database: forums   Table: search_cache 
  Structure   Browse   SQL   Search   Insert   Export   Operations   Empty   Drop   




Showing rows 0 - 0 (1 total, Query took 0.0135 sec) 
SQL query:
SELECT *
FROM `search_cache`
LIMIT 0 , 30 
[Edit] [Explain SQL] [Create PHP Code] [Refresh]


               row(s) starting from record # 
in  horizontal horizontal (rotated headers) vertical mode and repeat headers after  cells       

           id  ident  search_data 
      1470408961 tbaol a:5:{s:14:"search_results";s:2:"87";s:8:"num_hits"...
   Check All  /  Uncheck All   With selected:       


               row(s) starting from record # 
in  horizontal horizontal (rotated headers) vertical mode and repeat headers after  cells       

--------------------------------------------------------------------------------
Insert new row   Print view    Print view (with full texts)     Export


Bookmark this SQL query
Label:           
Let every user access this bookmark

Utrinque Paratus

12

Re: Base URL

Cache files in the root forum directory. [path/to/forum/dir/]cache/*.php. Remove those files.

13

Re: Base URL

Cheers Matt
spoken with my server provider and they are having a look for me, It unfortunately wont let me as owner administrator change thing in options etc or my fellow administrator get into the forum at all.
Regards
Huey

Utrinque Paratus

14

Re: Base URL

Hi all
matter now resolved by my server supplier who ahve cleared the cache? Thanks for your input. I am learning, S L O W L y.

Utrinque Paratus