71
Cozzie
Re: Changed to dedicated server and database can't connect - HELP!
  • 2008/3/10 2:48

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Now the site is working!

I changed the Database Hostname in mainfile.php from localhost to the ip address and (i think) that did it.

If anyone can explain to me why that did it it would be really helpful.

One thing remains however, I still can't use phpMyAdmin - it gives me "Access Denied". I've updated the user/password and so on but it still doesn't work. Does anyone know what the problem might be?

Thanks



72
Cozzie
Re: Changed to dedicated server and database can't connect - HELP!
  • 2008/3/9 1:18

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


No cpanel, no plesk (despite what the sales girl said)



73
Cozzie
Re: Changed to dedicated server and database can't connect - HELP!
  • 2008/3/8 14:03

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi terrion

Yeh, username for database is root



74
Cozzie
Changed to dedicated server and database can't connect - HELP!
  • 2008/3/8 9:56

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi there

Big problem and I am really lost. I just swictched to a dedicated server and can't connect to the database:

Going to the website gives 'db connection failed.'

If i try to connect to the database using phpMyAdmin i get 'Access Denied'.

I've checked and re-checked the username and password given to me by the web server host and I've got them correct on mainfile.php (and config.inc.php for phpmyadmin)

I'm guessing its to do with being on a dedicated server rather than shared host. It should be a managed server and the server host said they would transfer all files and set everything up but am i missing something?


Thanks a lot for any help



75
Cozzie
Re: Any module with suggestive search feature?
  • 2008/3/6 8:59

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


I've found the answer

I must have searched a dozen times for this but after making today's post the phrase 'auto-complete' came to mind so i searched for that instead of 'suggestive search' and there it was..

smart2 has done a great hack of isearch to do exactly this - many thanks smart2, its really appreciated!!!

You can find it here:

https://xoops.org/modules/newbb/viewtopic.php?topic_id=61635&forum=15&post_id=277687#forumpost277687



76
Cozzie
Re: Any module with suggestive search feature?
  • 2008/3/6 8:05

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Bump! Does anyone know of any way to do this?

Is there any module that can record all searches made and then use that record to give users search suggestions?

I know isearch can do the first part but don't think it can do the second

So if searches have been made for 'bananas', 'bandages' and 'bank', when another user types in 'ban' they will get the 3 suggestions but when they've typed 'band' they will only have bandages as a suggestion.

Is there any way to do this?

Thanks a lot for any answers, ideas or guesses!



77
Cozzie
Re: Any module with suggestive search feature?
  • 2008/2/12 8:51

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Thanks a lot irmtfan!

I've uploaded the articles module and tried to figure out how to get the suggestive search but can't see how to get it working.

Can you tell me how I can enable it?

Is there somewhere I can input a list of terms that I want to be used for the suggestive search?

Thanks again!



78
Cozzie
Any module with suggestive search feature?
  • 2008/2/11 3:07

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi there

Is there any module that includes a suggestive search feature - suggesting keywords as the viewer types in their search (like on Yahoo)?

Thanks!



79
Cozzie
Smartsection how can I change so User edits aren't auto-approved
  • 2008/1/25 9:07

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi there,

In smartsection, if a user has written an article they can edit the article (along with Admin) but I need to change things so that editing by users is not automatically approved (needs to be approved by Admin before changes take effect)

Can anyone help me on this?? I'm lost

Although the Preferences on the module allow you to easily select auto-approve for User submissions, it doesn't give the same choice for when a user edits an article.

I've been looking at it for some time but can't make it happen

Thanks a lot!



80
Cozzie
Re: Homepage doesn't open but other pages do?
  • 2008/1/23 1:53

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi John

No blocks added recently all this problem has gone on for a while now.

Sometimes I just get page could not open but sometimes I get "db connection failed"

I've seen this happen on XOOPS a few times,I guessed it was down to volume of traffic but that is unlikely to be the problem with my site

PS: I don't have gzip compression enabled because it messes up my site when i turn it on - could this be causing the problem?




TopTop
« 1 ... 5 6 7 (8) 9 10 11 ... 14 »



Login

Who's Online

121 user(s) are online (68 user(s) are browsing Support Forums)


Members: 0


Guests: 121


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits