Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#16 2008-06-10 23:02:26
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
haha, no, i’m actually fooling around with that mysql dumper right now. i’m in way over my head. it’s a neat tool, though.
Offline
#17 2008-06-10 23:15:58
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
goodness… something worked! or, at least, i was able to upload my sql without any errors. Now what? :D
Offline
#18 2008-06-10 23:29:56
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,316
Re: My god, what have I done?
Sorry, completely clueless now! =D
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Re: My god, what have I done?
brokenumbrella wrote:
i was able to upload my sql without any errors. Now what? :D
could it be that you’ve uploaded it but didn’t choose to restore the db from that file? also, i guess it would be a lot easier if someone would help you directly, look around in mysqldumper/phpmyadmin and fix it for you. remotely describing this kind of procedure can be tough. (that person wouldn’t be me though, i’m busy :P — uli? haha)
Offline
#20 2008-06-10 23:35:09
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
Hahaha, it is pretty weird. my brain is packed with too much new stuff. head explody
right now i’m trying to figure out if i should reinstall txp or try some sort of update thing.
Offline
Re: My god, what have I done?
brokenumbrella
At some point you will need to go update or create a new config.php file. It is located in your textpattern install under /textpattern/config.php
Until then Txp won’t see your database.
edit
sorry – I didn’t see your most recent post. Must have crossed.
You said that this site was built for you some time ago?
- If your original install was heavily modified
- If your site hasn’t been updated for since it was created,
- If you need your site back up asap
Then you may want to keep the same version of txp for now, and update later.
However, if it were me, I’d probably install a fresh version of the latest Txp release and bring everything up-to-date.
(to be more accurate – I’d install the latest svn version, but that’s beside the point).
With a fresh install, you can then drop in your updated config.php file and you should be able to connect to your database. Remember to remove the /textpattern/setup folder
Mike
Last edited by maverick (2008-06-10 23:50:48)
Offline
#22 2008-06-10 23:43:14
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
Thanks, maverick. I just did that (actually just edited the old config by specifying a table prefix). it still wants me to do a setup, though. but the tables are already set up, aren’t they? since i imported the sql?
Offline
Re: My god, what have I done?
re: the configuration file
You will want to make sure the the user name and password and mysql host for the new host is updated also. These are more important. The table prefix is the optional if I remember correctly.
re: the tables
Did you use the “restore database” option?
If so, you should be able to see the tables, and if you browse them you should be able to see the data.
Mike
edit
If you don’t have the config file set up properly, it will want you to do a full set up. If it is correct, it seems like it goes to the set up page, but gives a warning that it appears that the configuration file already exists (I think – its been a while since I tried that. Normally I drop in my config.php and delete the setup file at the same time).
Last edited by maverick (2008-06-10 23:57:53)
Offline
#24 2008-06-10 23:58:50
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
I’m afraid to touch them tables; i already deleted them all then restored them with the sql from my old host. the current message reads “Textpattern database table already exist. Can’t run setup.”
Offline
#25 2008-06-11 00:01:11
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
Aaaand I went and deleted the setup folder, so now i’m getting something like this:
Warning: Table ‘inadar5_brokenumbrella.txp_lang’ doesn’t exist select name, data from txp_lang where lang=‘english’ in /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_db.php on line 81
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_misc.php on line 180
Warning: Table ‘inadar5_brokenumbrella.txp_lang’ doesn’t exist select name, data from txp_lang where lang=‘en-gb’ in /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_db.php on line 81
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_misc.php on line 180
Warning: Unknown column ‘nonce’ in ‘field list’ select nonce from txp_users where name=‘curious umbrella’ AND last_access > DATE_SUB(NOW, INTERVAL 30 DAY) in /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_db.php on line 81
Warning: Cannot modify header information – headers already sent by (output started at /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_db.php:81) in /home/inadar5/public_html/brokenumbrella.com/textpattern/include/txp_auth.php on line 169
Warning: Cannot modify header information – headers already sent by (output started at /home/inadar5/public_html/brokenumbrella.com/textpattern/lib/txplib_db.php:81) in /home/inadar5/public_html/brokenumbrella.com/textpattern/include/txp_auth.php on line 170
ewwwww.
Offline
Re: My god, what have I done?
brokenumbrella
Don’t panic – those error will go away. But they aren’t fun to look.
The warning makes it sound like the table are present.
In your configuration file, are you sure you have the right:
- database name, (this may have changed)
- user name (this may have changed)
- password, (this may have changed)
- database host — this will have changed. It may or may not be the same as your website, depending on your new host’s setup. For example, the default install is “localhost”. But with Dreamhost you had to put in the MySQL server that was assigned to your website.
- txpath for the new host is correct. This will have changed with your webhost change.
Last edited by maverick (2008-06-11 00:14:58)
Offline
#27 2008-06-11 00:17:15
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
Right now it says ‘localhost’, which actually worked before. Hrm.
Offline
Re: My god, what have I done?
Your new host should provide you with the info you need – either through an email or their control panel.
When you say it says “localhost”, and it worked before, when do you mean it worked? @ Dreamhost?
Offline
#29 2008-06-11 00:21:17
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
No, I actually had textpattern (but no website) up and running before I went in a wrecked everything. I installed a the new version and added a bunch of plugins and stuff. Then I took it all down when I restored the sql thing.
Offline
Re: My god, what have I done?
clarification – Just in case I miscommunicated – when I say that the database host will have changed – I mean from the config. file you used with dreamhost. Not from installing Txp.
Offline