Bump!
2 2008-10-09 21:19
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Still no luck
Ok, here is how it goes:
- I enter SQLiteManager
- I add a new Database (name it the same as my database is named and browse, select and upload the database-file)
- I can now browse this database.
- Everything seems fine.
But I don't get the same info as I can see if I open the file with notepad. When I open the database with notepad, all IP's listed in there are my "old one", but every post is in it (all new as well), so it got to be my working database? Tho, in SQLiteManager o_base_url and all other rows containing a url are set with my new IP. This confuses me, as I can't change it to the IP I currently have, couse it allready is!
So, since I don't know any other way, I export the file. Now, when opening the database, all the IP's are as the old one again.
As I said, confusing
So, next question: When I export, what happends? Couse none of the files I see accually update (looking at the database itself and the file created in the SQLiteManager folder when I add a database there).
Are you sure I should now check any of the options when exporting?
Again:
Structure :
[ ] Add "DROP"
Data :
[ ] Complete inserts
--------------------
[ ] send [ ] CRLF
Sorry for beeing back bothering you, but I really want to get this to work
3 2008-10-09 18:24
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Gonna do a little bump here!
Ok, so as it is now, I have found my SQLite database, managed to configure it. But I'm still stuck at the "Export" part. How do I update my database? I'm abit afraid to click all the options that "SQLiteManager" have on the Export part.
If anyone know how the export works, I would appriciate if they could inform me.
-What options need to be checked?
Add "DROP" (?)
Complete inserts (?)
send (?)
CRLF (?)
And what do I export?
-Structure only
-Structure and data
-Data only
4 2008-09-04 15:49
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
When changing $db_type to mysqli I get this when trying to open the forum again:
This PHP environment doesn't have Improved MySQL (mysqli) support built in. Improved MySQL support is required if you want to use a MySQL 4.1 (or later) database to run this forum. Consult the PHP documentation for further assistance.
Also, I tried to import the "forum2" file I had into the phpMyAdmin thingie, getting the error that it's a sqlite DB.
It might just be me, but I didn't quite understand how I manage the sqlite DB? When using that program you spoke of, I needed to import the DB's. With phpMyAdmin I can log in and get to this page with easy overview over the databases etc. I wonder if there is any way to log into the sqlite thingie in any simular way?
This is getting more and more complicated, hehe.
5 2008-09-03 21:01
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
The PunBB thingie is something I created I think. I tried to do a new installation once, and that works. I can accually see all things in this now (Didn't quite understand it untill now!).
Where is this $db_name ? Is it inside myPhPAdmin I should look for this? Or in the file called "forum2" in my forum folder?
And as it seems like the database installed correctly the second time I installed it (another forum tho), is there any way I can "kidnap" that db and make it the counting one for my original forum (if anything of that made any sense ).
Anyways, I'm to tiered to look trough this now. Gonna have a look tomorrow. I've learned alot allready tho, so I am indeed gratefull for all your help!
6 2008-09-03 14:40
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Hmmmm, I don't know if I'm accually importing it anywhere. When I push "Export" I get a new file (forum2.sql) that I replace the forum2-file I have in my / with. How else do I import anything?
And what should I be using mysql for? (Does SQLite count as MySQL?) And how?
7 2008-09-03 14:20
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Allright, now I'm getting somewhere!!
I load the forum2 DB with sqlitemanager, find the o_base_url row and edit it.
But then I'm halted again
I tried the "Export", with many different options checked out, but the new file I get end up beeing 2/3 of the original one, not the same file-type and my forum won't accept it. Says it's eighter encrypted or not readable.
I've tried rename the file to the same name without any luck.
I didn't know the file "forum2" in my / was the database itself. But now I know atleast
Hoping you can guide me further on to my next step!
And again, thanks for all help!
IB
8 2008-09-03 12:44
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
It's accually running on a QNap NAS server. I have a Linux box as well (the one I spoke of from ~2000) but failed installing php on that one, so the NAS was a easy solution for me. It got phpMyAdmin and sqlite installed.
9 2008-09-03 04:25
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
You're right, phpMyAdmin sais it runs MySQL. Maybe this is the problem. May I ask how you access the sqlite? Is sqlitemanager a program installed with sqlite or do I need to download this seperatly?
Thanks for helping me progress!
10 2008-09-02 21:37
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
I have no idèa of what I'm talking about!
Ok, to start from scratch:
-I have a forum (with users, posts etc etc.)
-Works normal for all "normal" users.
-When I try to "upgrade" the forum with "addons" I fail because they can't access/find/write to the database.
-I do not find the database myself neighter (accessing phpMyAdmin to look for it). However there is a file called forum2 in / that "grows" over time. My guess is that this is the file that have all my data? But how to get this info into sqlite/phpMyAdmin so the computer understands it?
Does this mean I don't have a database, or is it hiding?
Can I do something about it, or do I have to let it be as it is to be able to keep all users/posts?
11 2008-09-02 20:20
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Hmmmm, is there no way to transfer my posts from the forum I currently have?
I wouldn't like to loose everything in it.
edit:
What you're saying is that I should delete all and start all over again? That I would've managed, but that reason I asked for help was to be able to keep users/posts from my currently one.
12 2008-09-02 18:22
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
What will happend when I delete the config.php file? What configurations will I loose?
And what will I loose by re-installing?
Will try this once I've made a backup!
13 2008-09-02 13:59
Re: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Yes, I'm running version 1.2.x. I started with 1.2.17 and have updated it. Atm I got 1.2.20.
When I open my config.php I find the info:
$db_type = 'sqlite';
$db_name = 'forum2';
This is correct, I installed sqlite.
When I log onto sqlite I see a DB named forum2 ...but this DB have 0 tables in it. So it kinda leeds nowhere. I also find 4 other databases in it (who of them I've created I can't remember):
-PunBB (17 tables, all starting with fs_*)
-web (36 tables, all starting with jos_*)
-mysql (17 tables, no pre-marking)
-information_schema (16 tables, no pre-marking)
This is the reason I manaully changed the IP adress in the cache file, because I never found o_base_url.
I don't really think I created a DB here before I installed the forum for the first time, as I didn't exactly know what I was doing. After reading alot about PunBB over the last year, I now have a better understanding and would know how to set up a forum from scratch again. But since I don't want to loose anything on my existing forum I wonder if there's any way of saving the one I got
Anyways, thanks for the reply!
14 2008-09-01 21:49
Topic: Beginners problem (24 replies, posted in PunBB 1.2 troubleshooting)
Just to get it mentioned, I'm not that updated on php, PunBB and MySQL stuff (and that might be the problem )
My problem is:
I installed PunBB soon a year ago, first time doing anything like it. It works fine for standard use, but I've made a few mistakes, so I can't do anything more than to just "have a forum". Somehow, somewhere in the installation I must have missunderstood the part where you spessify the DB you'll be using. So I don't really think my forum uses any DB at all (?) I've been looking in the SQLite looking for a DB that I can lead back to PunBB queries without any luck.
- This prevents me from installing any mods etc.
- And also when I moved the server once I had to manually configure the cache/cache_config.php with the new IP address to be able to do anything as an Administrator (As I'll allways be rederected to the IP spessified in Options). If I do any changes in Options, the forum rederects me back to the old IP. (This makes me think the data must be stored somewhere, but I just can't figure out where).
So my questions are as follow:
- How can I check what DB my current forum is using?
- If there is no working DB for my forum, can I create one?
I guess you need more info to help me, but I wouldn't know what info, so don't essitate ask for more details.
Have my hopes up for advices on this!
IB
15 2008-05-16 18:03
Re: Control Panel error (7 replies, posted in PunBB 1.2 bug reports)
Administration -> Options -> Features -> Additional menu items