XAMPP setup preconfigured for IntegraMOD.

[Fubie]

Yes, you can use it. Just place your db file in c:xampphtdocsmysqldumperworkbackup

[Fubie]

oh, and create a new sql db in phpmyadmin per the tutorial.

[ayasha]

it is working <img> so far so good, at present, it is still dumping the data into the database.

now, how can i get this mysqldumper on my host to use for backing up and restoring my database?

[Michaelo]

What ever you do don't wash the dishes before restoring, I tried it once but never againà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦
Whats this bigdump thingy I only use phpmyadmin export is there a better way?

[ayasha]

ok, got the database in and when i go to open sites, and click on the one that i have been setting up, i get this


Warning: mysql_connect(): Access denied for user 'ayasha'@'localhost' (using password: YES) in C:xampphtdocsforumdbmysql4.php on line 54

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 571

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 572
phpBB : Critical Error

Could not connect to the database

i am wondering if i would not be better off to wait, until i can afford the amount of space i had before, and just setting up all the "testing" forums i had on a server somewhere and not my comptuer. if each one is going to be as hard to setup, but i am hoping it is just me and i will get the hang of it because if i could have all this on my HD i would only need 1 live forum.

and Mike, the MySqldumper looks to me like a seperate program you would install on your hosting to mangage large db's with, but i don't know, Fubie would be the better one to answer

[Fubie]

Big dump imports a large db into your sql db in chunks. It's 1 file and is very simple to use.

mysqldumper is more complex. It backs up manually or via a cron job.

You can download each [url=http]Here.[/url]

[Fubie]

cleo,

You need to edit your db in phpmyadmin to reflect your new domain and db setup.

Your domain on xampp will be localhost.

[ayasha]

well, one thing is for sure, i am sure getting an education doing this, what do i edit?

when i set up my forum, and i filled out the info on the install, i used 'localhost'

so is there somewhere else i need to edit?

edit: in the table phpbb_config, would i change

server_name graphicsplayhouse.com

to

server_name localhost?

again, i do apologize for asking so many questions.

[Fubie]

Edit your config.php to reflect your new db name and password.

go into phpmyadmin in xampp, open your new db from the left.

click on the SQL tab at the top.

You should get a large empty box.

Below in the code replace forum with the folder name you are using for your forum.

Then pasteit in the box and hit Go.

UPDATE `phpbb_config` SET `config_value` = '/forum/' WHERE `config_name` = 'script_path' LIMIT 1 ;

then goto that SQL tab again and past this in it.

UPDATE `phpbb_config` SET `config_value` = 'localhost' WHERE `config_name` = 'server_name' LIMIT 1 ;

Hit go.

Then see if your forum comes up.

[ayasha]

well, here is what i did

i named the database i created the same as the one i was using, used the same user name and pw.

the folder i have my forum in is named forum, so i did not have to change anything in that line

i ran both lines, and it changed and gave me the message everything was done ok,

but i still cannot get to my forum.

[Fubie]

Could you post the error if it's a new one?

[ayasha]

Warning: mysql_connect(): Access denied for user 'ayasha'@'localhost' (using password: YES) in C:xampphtdocsforumdbmysql4.php on line 54

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 571

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 572
phpBB : Critical Error

Could not connect to the database

doesn't look new to me, but i may be wrong

[Fubie]

can you confirm that mysql is running?

Thats a db connect error

[ayasha]

yes, it is running, i am just going to walk away and watch some tv for awhile.

i might even delete it all and begin again when i come back, just know i am getting a bit frustrated, and now my son i shome from school, and my hubby is up, so time to get his meds out and see what he needs today.

thank you so much for your help Fubie, and when i get back to this, if i still have the errors, i will let you know.

it is connecting with the im140 just fine, but not the one i added.

[Fubie]

ok <img>

[Michaelo]

In main xampp page select phpMyAdmin click on privileges and make sure ayasha is there and give the privileges needed (same as root). If you are not there add ayasha with the same password as you use in the config.php file and set privileges to %(all databases) privileges to ALL PRIVILEGES should be same as root.

Mike

[ayasha]

well, that seems to be where the problem is in the phpMyAdmin, when i click on that, i get

Error

MySQL said: Documentation
#2003 - The server is not responding

when i click on the start for MySql, it will start, stay green with the word running for a sec, then stop. it will not stay connected/running whatever you want to call it.

[Fubie]

you may want to start from scratch and take it one step at a time. It is even possible that your db was not imported correctly.

Try running mysqldumper in IE or Opera. It has gotten stuck a time or two in FF.

[ayasha]

why won't the MySql stay running? and i did start from scratch, i even uninstalled and installed again.

[Fubie]

oh I see, mysql keeps shutting itself down.

I'm not sure really, I'll do some checking to see if anyone else has had this.

Back shortly.

[ayasha]

thanks Fubie, i appreciate that

[Fubie]

Cleo, can you turn off any antivirus and firewall software including windows firewall and try it?

[ayasha]

i turned them both off, it made no difference.

[Fubie]

what version of win XP do you have and what service packs.

Do you have any security software at all running.

Please run the xampp-portcheck.exe in the xampp folder. Make sure everything is free.

[ayasha]

all i can tell you is i am runnign win xp, i use windows firewall, and mcaffee.

i have no other security software running, and i am up to date on all the windows updates, sorry i don't know what version of xp or what the service packs are.

i ran the port check and everything is free, but still no go on the MySql.

[Fubie]

Ok, this is my last idea. goto the xampp folder and run mysql_start.bat

Hopefully that will start it.

[ayasha]

well, keep your fingers crossed Fubie, that did it for the mysql, and i can connect to the im140.

now i am going to get my database back in, and hopefully everything will stay working <img>

[Fubie]

Geeeze.......... It's the simplest things. <img>

[ayasha]

ok, got that forum up and running on my HD, but now i am faced with a new problem, how do i get into the acp?

it keeps taking me to

//http://graphicsplayhouse.com/forum/login.php?redirect=admin/index.php&admin=1&sid=93598ac689c72f274fd9647db760951f

and that is not the localhost. if i manually type in the url

//http://localhost/forum/admin/index.php

it stills tries to take me to the first url. any ideas now?

edit: i got in, kept messing with the url til i did, now let me get everything i wanted off this one, and get rid of it. <img> it has been such a headache.

but let me go ahead and ask this question, when i set up a copy of my live forum on my HD, will there be any problems when i do upgrades, in getting the upgrades to work right on the live forum? as you can see with the 2 urls i used above. will the "localhost/forum/index.php carry over to a live forum? or will it be right when i upload the modded files and run the sqls on the live database on the server?

[evolver]

I've had the same problem...

But there is a simple way...
When trying to log in, I was taken to my online forum...
http://yourdomain.com/forum/login.php?sid=xxxxxxxxxxxx

Solution:
In your browser, change 'yourdomain.com' in that URL to 'localhost' (but keep the rest untouched)
http://localhost/forum/login.php?sid=xxxxxxxxxxxx
By doing so, you can login to you xampp installed forum

Once you're inside your admin panel, change domainname in your config.
The next time, you won't have that problem anymore!!

[ayasha]

yep, did that, but my concern now is, when i do updates and mod, will localhost carry over to my live forum? that is what i am asking now.

[evolver]

yep, did that, but my concern now is, when i do updates and mod, will localhost carry over to my live forum? that is what i am asking now.

You can integrate new mods and updates in your xampp installation...
There's no way, for them to be transfered to your online forum...
xampp is no FTP-program, and it doesn't even have the permission (username and password) to do so.

But maybe you're concerned about the SQL database?
As long as you are working on localhost, it will only use the SQL from localhost...

[ayasha]

ok, let me put it this way

i want to do a mod

i mod the files on my localhost and all works fine

i open up my ftp program, transfer the modded files to my live forum

i go to myphpadmin in my cpanel and run the sql quieries.

will there be anything in the modded files, that will carry the url 'localhost' over to the live forum?

[evolver]

Cleo, those files call a domainname, specified in config.php
Only config.php holds the information to a domainname, MOD's never take place on config.php
Just never overwrite config.php by the one from your xampp testsite!!

To play it safe:
Keep a backup of config.php from your online site at special place...

For SQL quieries on xampp, you will use the MOD instructions...
For SQL quieries online, you will do the same.
So...they can't have any influence from each other...

[ayasha]

thank you

[Michaelo]

I keep two copies, one is a complete unmodified copy of my site and the other is the one I modify. If after update the site I find major errors I can simple upload the unmodified copy. As evolver said, (most important point) always keep a copy of you site config some where safe, its real easy to accidentally overwrite it (Ive done hundreds of time <img>

PS If you want to keep the database size small, you can dont really need the search word and dictionary/spell check tablesà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ They are often very bigà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦

[Okki]

Is there a xampp version with apache 3?

we have a few problems with some of the IM scripts, and the server is running apache 3

[Michaelo]

Where did you get version 3? The trunk is only 2.4

[Okki]

SERVER_SIGNATURE Apache/1.3.33
SERVER_SOFTWARE Apache 3 - HOSTMerit

[Michaelo]

Ah that's 1.3.33. I can't find any older verions but it should be possible to install xampp and download apache 1.3 and replace the apcahe 2 by over writing it...
Mike

[HaLiMaW]

eAccelerator for php 5.1.1 found somewhere from a user in xampp forums. Now I can use mod_rewrite + speed of eAccelerator.

As soon 1.5.2 will be realease, I will remove the file from my server.

Quick stepts to install :

1 : download and put the file in phpext
2 : open apachebinphp.ini

Modify it to look like this :

Code:
extension=eAccelerator_511.dll
eaccelerator.shm_size = "0"
eaccelerator.cache_dir = "C:apachefriendsxampptmp"
eaccelerator.enable = "1"
eaccelerator.optimizer = "1"
;eaccelerator.debug = "0"
;eaccelerator.check_mtime = "1"
;eaccelerator.filter = ""
;eaccelerator.shm_max = "0"
;eaccelerator.shm_ttl = "0"
;eaccelerator.shm_prune_period = "0"
;eaccelerator.shm_only = "0"
eaccelerator.compress = "1"
eaccelerator.compress_level = "9"
eaccelerator.keys = "shm_and_disk"
eaccelerator.sessions = "shm_and_disk"
eaccelerator.content = "shm_and_disk"
;eaccelerator.admin.name =
;eaccelerator.admin.password =

It's hard to tell for me if this is the best config to get the fastest speed, but it works great.

[Michaelo]

Must have a look I love speed <img>

[Tumling]

I just installed this and i get this error on top of the forum

[code]Warning]

What is that about ?

[Michaelo]

Sorry Tumling, what you installed?

[Adrian Rea]

I think this is the preinstalled 140 forum in Fubies preconfigured Xampp


A

[Fubie]

It only occurs on the windows servers. Can you try to delete the test topic and clear cache and resync stats?

[Neo]

Wow .. fubie ... You make it possible for do a local testing much more easier... Thanks a Million .. Keep up the Good work

[ayasha]

well, my XAMPP is running mysql5. i have done the switch and the DOS window says it is changed to mysql4, but it does not really change, when i bring the XAMPP back up, and check, it is running mysql5, any suggestions?

[Fubie]

open a DOS window by going to Start>Run> type cmd

type cd hit enter

cdxamppphp-switch.bat

You should get the switch dialog.

[ayasha]

ok, when i asked about setting this up on USB drives and other partitions, i basically got the understanding that it was ok to do this.

now i must ask, could this be my problem? because i do not have it set up on the c drive? but another partition?

[Fubie]

oh, ok, No, this shouldn't be the issue.

I have miine on a flash drive as well.

As long as xampp folder is in the root.

Replace the C for your drive letter.

[ayasha]

well, i get a directory name not valid.

and isn't this the same as executing the php-switch.bat file? when i do that, the window comes up and tells me the working version in xampp is PHP 4.

[Fubie]

if that's what you get by clicking the php-switch.bat file you need to do it thru the command line as I posted above.

[ayasha]

the command line gives me the directory name not valid.

[Fubie]

which line?

[ayasha]

here is a copy of my DOS window

[flash=,:a6am9fyh]http://i6.photobucket.com/albums/y248/ayashazoelle/Image1.jpg[/flash:a6am9fyh]

[Fubie]

I'm sorry Cleo, My fault. I'm doing to many things at the same time.

Do the cdxampp

then php-switch.php

[ayasha]

ok, ran the dos command and here is what it says

[flash=,:18r5vgt4]http://i6.photobucket.com/albums/y248/ayashazoelle/dos.jpg[/flash:18r5vgt4]

now i go to myphpadmin and it says i am running mysql5

[flash=,:18r5vgt4]http://i6.photobucket.com/albums/y248/ayashazoelle/phpmyadmin.jpg[/flash:18r5vgt4]

all i know, is i did the upgrade for php2.0.20 and when i try to quote i get this error


Error geting users post stat

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM phpbb_groups g, phpbb_users u LEFT JOIN phpbb_user_group ug ON g.group_id=ug.group_id AND ug.user_id=2 WHERE u.user_id=2 AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>2

Line : 771
File : functions_post.php


i was told this is an error that has to do with php5, and it does not seem like my xampp will switch from 5 to 4, even though the dos window tells me i am running 4, myphpadmin says i am running 5.

i just don't know how to fix this.

[Fubie]

From your screen shots it looks like you were running php4.

Try switching it again.

[ayasha]

so the one that says

Welcome to phpMyAdmin
mysql 5.0.18 running on local host

is not the sql i am running?

and i have run the php-switch.bat about a dozen times, switching it.

and does the error have to do with php5?

sorry i am asking so many questions again.

[Fubie]

The best way to see what version of php is running look at your xampp menu in the upper left corner.

[flash=,:344ccn7w]http://www.fubie.net/images/XAMMP0.jpg[/flash:344ccn7w]

[Michaelo]

Cleo, have just checked and it always says MySql 5.0.18-ntà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ no mater which version you are running. In the DOS window if it the option is 4, its running 5 and if its 5 its 4 also on the home page it displays the correct info.

Have quick check to see if the 2.0.20 update missed any table entries ( I will have a look here) just in caseà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦
Mike



[color=darkblue]Added]
Cleo did you use the update script when updating and did you have some moderators added before updating?

[ayasha]

thanks Fubie and Michaelo, i know for sure now, i have php4 running.

i used the update_to_latest.php that came in the zip folder Michaelo.

i have changed nothing about my moderators. i had 1 before the update and still have the same 1 now.

[Michaelo]

The only thing I can think of is an error in functions_post so here is one that I know works.

Cleo compare the two files... might help <img>
Mike

[ayasha]

thanks Michaelo but i am going to consider myself lucky <img>

i know this is a thread about XAMPP and i am sorry for asking so many questions that ended up dealing with the php upgrade.

[Michaelo]

No problems Cleo, if we set up a forums for everything we'd have nothing but forums besides we can tidy it up later... <img>

[Wiked]

Thanks for this Fubie.It rocks to be able to do this.

My localhost forum is working great when you are a guest looking around. Then when you log in as a normal user it still works perfectly.

The problem is when I log in under my admin then I get the following error:

[size=99px]
[/size]

Of course I need to log in as admin or whats the point...lol.


All light you can shine on this would be greatly appreciated.

[Fubie]

Is this error when using the pre installed IM 140 or one you installed?

[Michaelo]

You don't have a mail server set-up on your local system... So you can't send mail... Just ignore the error messages or set-up mercury mail or any mail server.
Mercury Mail comes with Zampp... Has any one set it up?
Mike

[Wiked]

Fubie,

Sorry mate...its my forum I installed.

If I ignore the error message then I still cant log in as admin so thats no good to me. If I have to install the mail side of it then thats OK but I cant understand why as I can log in as a normal user normally.

[Fubie]

Can you login as admin into the pre installed forum?

[Wiked]

Yes I can Fubie. No probs loggin into the im140 forum as admin

[Fubie]

Then there is something not right with your install.

Can you wipe your install and retry it?

Also, is this a clean install or are you putting your live forum on here to toy with?

[Wiked]

I did uninstall it and then re install before I asked you and still does the same thing.

Its my modded forum that I use and want to have it on here to do more custom additions as I have members that are on 24 hours a day and this will save me changing it live and giving them some errors occasionally.

Also before I added the MySQL part today I always could log into the forum as admin while pulling it off my server database

[Fubie]

I'm really not sure why it is giving that error. None of my forums have done it.

I'll see if I can find an answer some where.

[Fubie]

Do you use the default theme?

If not can you try switching it?

[Michaelo]

Some info on mail settings with XAMPP
If you set option à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€¹Ã…“inform me of replies or these are automatically set the system will attempt to send them emailà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ If the email error pops up on a real/active site please state the problem in not with XAMPPà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ else we could go around in circlesà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ <img>

[Wiked]

Fubie, I use AcidTechTiger and dont have any other template on my forum.

Michaelo, I don't have that problem at all on my live forum and never have actually.

Anyway after a 4th install it finally works where I can finally log in as admin. So this problem is now fixed.

Now the only problem is that when I try to use the (PM, Admin & Memberlist) links then it go to http:and hense in firefox goes to microsoft.com and in IE 'Page cannot be displayed'.

I can manually type in the correct addrress and it still does the same thing.


These are the only 3 links that don't work. All others work 100%.

Any ideas on this one?

This is not a big deal I guess as I wouldnt ever use 'memberlist' and wouldnt go into private messages unless I was changing something in there.

Thanks for the help as on the other site you would wait days or weeks for an answer. <img>

[Michaelo]

Wiked, add fisubice to make sure its not template related (I dont think it is) but this may help down the road as we are using fisubice as default.
It does seen XAMPP related so Fubie may be able to sort it out for you.
Mike

[Fubie]

From everything I've read it points to a theme issue in IM that xampp has a problem with.

Wiked, Can you install fisubice on your live site, Set your admin to use fisubice, then redownload it and your db to xampp and see if that helps?

[Wiked]

Sorry for all the dramas guys but I fixed it myself.

I had placed http://localhost as the server name in the config table where I should have just had localhost

This has fixed the problem.

Sorry and thanks for you help.

[Fubie]

lol.. No probs.. At least it was simple.

[Frostvarg]

cant find the files, would love to try this

[Fubie]

Sorry, My host is experincing a few issues, everything should be resolved soon.

[ayasha]

ok, i am at a loss here. i added themes to my live forum, but it does not seem possible to add them to xampp.

when i try to switch to any other theme beside fisubice, it signs me out, it will display the theme i switched to at this point, but when i click on "log in" it switches me back to the fisubice clone i made for my theme.

any help would be appreciated. i was wanting to apply the modding to any theme files that needed it before applying them to my live site, but it does not look like i will be able to do that.

thanks in advance guys <img>

[Fubie]

I haven't tried that in xampp yet, I'll try to test it today.

[ayasha]

thanks Fubie <img> much appreciated!

[Michaelo]

Cleo the themes for 1.4.0 don't work in 1.4.1 (at least not completely), try this it works for me...
[url=http]SlateB... Right Click and save as[/url]
Mike

[ayasha]

thanks for the link Mike, but i am not trying to install themes on 1.4.1.

i am really asking a question about xampp here, my present forum is running on 1.4.0 and i have been adding themes to it, but, the duplicate copy of my forum i have set up in xampp, will not allow me to switch themes.

so i am trying to figure out why.

[Michaelo]

Sorry Cleo... I best re-read the thread

[ayasha]

that is ok Mike it is just puzzling me, if we cannot switch themes on xampp, then in order to test to see if we have alot of mods working right with other themes, i guess i will have to set up another test forum on my server <img>

[Fubie]

Here you go Mike <img>

http://www.fubie.net/geek/dload.php?act ... file_id=20

Cleo, I'm still trying to get to this to test it. Sorry it's taking so long. Just as a test, have you tried it on the pre installed 140 forum in xampp?

[ayasha]

no, i have not tried it on the pre installed 140, will try and get to that some time today.

i understand it may take some time for you to test this out, don't sweat over it, it is nothing major.

[ayasha]

well, it allows me to change themes on the preinstalled IM140

[grizzly_cs]

Ok First things first Great Job Fubie and thanks to all the rest for the tips ...

I got my live site down and the database loaded, with minor difficulties..

However when I go to start the board I get the banned error... I have had this problem before on the live board and fixed it with the acp from another admin login... To the life of me I cant figure out the why... hehehe or maybe to much work and not enough fun lately...

[Threat009]

This is a powerful little tool! I was playing around w/it last night. Love the fact that I can test away, w/no worries. Thanx for this! I'm sure I'll be back w/some question soon / lol..........

[grizzly_cs]

Ok got that last one figured out, I did not know my live site banned the local host or when it was done or why...

But now when I load up I get a blank page???

[grizzly_cs]

Well its up and running , had to go to my live board and repair the cat and forum stuff in the database then rebuild the includes/def_tree.php.. But its works great now... now to bring the site up to date locally

I must say mysqldumper is a very handy tool...

Thanks

[Fubie]

Glad you got it going.

Yes, mysqldumper is very nice.

[Frostvarg]

preconfigured and i cant ad more admins, cant change the number of allowed admins in security panel.