I searched around and could not find any other posts on my problem and did not see any docs. If I've overlooked something, please let me know.
I recently attempted to install PHPWiki on my site. I altered the config.ini file to change the DATABASE_DSN, ADMIN_USER, and ADMIN_PASSWD. I'm sure there are some other parameters that need adjusting for my particular install.
When I try to load the page, I get the following error:
* DB Error: no such table
* (SELECT page.id as id, page.pagename as pagename, page.hits as hits, page.pagedata as pagedata FROM page WHERE pagename='global_data' [nativecode=1146 ** Table 'kristina_gtd.page' doesn't exist])
*
Any ideas on what I've done/not done/need to do?
Thanks,
Joey
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Joey, did you run the MySql script to build the initial basic database structure? It looks like you are missing the table definitions. Reread the installation instructions about incorporating the Wiki into a database.
MikeP
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No, I don't think I did...but I will. Is it possible for me to do on my shared host? If so, are there any docs on that? The installation instructions you are referring to are located in the config.ini file?
Thanks for your help,
Joey
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm also a newbie, but I do know where the installation instructions are!
There is a file INSTALL in the phpwiki directory and there are installation files for each backend (if I've got that right) in the doc directory. I was very disappointed to open up the INSTALL.flatfile file to discover that the flatfile backend is broken. I guess this comment means that the rest of the instructions are for version 1.2.x and not for 1.3.x?
Eve
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, you can do this on a shared server because the Wiki has it's own database under MySql.
As to the documentation, it has been a long while since I last installed my wiki, but I remember finding it somewhere in the kit... did you look in the DOC directory? I think you'll find there instructions for installation with the different storage techniques/tools.
In addition to the basic release kit, there is a CVS repository that contains patched versions of various modules since the release kit was shipped. However, it does require the installation of WINcvs package (or other similar utility) to access this patch facility properly. It's not difficult to learn, but it is one more thing to deal with when getting your wiki started.
Look in the wiki help forum and patch forum for specific and general notes. I found several good suggestions and hints there that answered my questions nicely.
MikeP
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I believe that the database and username must be created before the installation can proceed.
The phpwiki database can be shared with an existing one, but you will need to supply a phpwiki prefix (typically phpwiki_) for all tables. You can find this in the config file as well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ah, one more thing I forgot... look in the schemas directory for the wiki for the database initialization scripts to build the first database structure. There's a script for each of several database engines.
MikeP
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'd agree with Andrew that the wiki can be safely inserted into an existing database. But I'd not recommend it. Some time later down the road you're likely to want to move the wiki to another location due to size, performance issues. That's more difficult if it is blended into a database with other applications. Make it as it's own database with it's own protection and access privs. You'll be happy later on as the wiki catches on and grows.
MikeP
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I searched around and could not find any other posts on my problem and did not see any docs. If I've overlooked something, please let me know.
I recently attempted to install PHPWiki on my site. I altered the config.ini file to change the DATABASE_DSN, ADMIN_USER, and ADMIN_PASSWD. I'm sure there are some other parameters that need adjusting for my particular install.
When I try to load the page, I get the following error:
lib/WikiDB/backend/PearDB.php:778: Fatal[256]: wikidb_backend_mysql: fatal database error
Any ideas on what I've done/not done/need to do?
Thanks,
Joey
Joey, did you run the MySql script to build the initial basic database structure? It looks like you are missing the table definitions. Reread the installation instructions about incorporating the Wiki into a database.
MikeP
Mike,
No, I don't think I did...but I will. Is it possible for me to do on my shared host? If so, are there any docs on that? The installation instructions you are referring to are located in the config.ini file?
Thanks for your help,
Joey
I'm also a newbie, but I do know where the installation instructions are!
There is a file INSTALL in the phpwiki directory and there are installation files for each backend (if I've got that right) in the doc directory. I was very disappointed to open up the INSTALL.flatfile file to discover that the flatfile backend is broken. I guess this comment means that the rest of the instructions are for version 1.2.x and not for 1.3.x?
Eve
Thanks for the heads up.
flatfile is fixed, for both trees, 1.2.x and 1.3.x
Yes, you can do this on a shared server because the Wiki has it's own database under MySql.
As to the documentation, it has been a long while since I last installed my wiki, but I remember finding it somewhere in the kit... did you look in the DOC directory? I think you'll find there instructions for installation with the different storage techniques/tools.
In addition to the basic release kit, there is a CVS repository that contains patched versions of various modules since the release kit was shipped. However, it does require the installation of WINcvs package (or other similar utility) to access this patch facility properly. It's not difficult to learn, but it is one more thing to deal with when getting your wiki started.
Look in the wiki help forum and patch forum for specific and general notes. I found several good suggestions and hints there that answered my questions nicely.
MikeP
I believe that the database and username must be created before the installation can proceed.
The phpwiki database can be shared with an existing one, but you will need to supply a phpwiki prefix (typically phpwiki_) for all tables. You can find this in the config file as well.
Ah, one more thing I forgot... look in the schemas directory for the wiki for the database initialization scripts to build the first database structure. There's a script for each of several database engines.
MikeP
I'd agree with Andrew that the wiki can be safely inserted into an existing database. But I'd not recommend it. Some time later down the road you're likely to want to move the wiki to another location due to size, performance issues. That's more difficult if it is blended into a database with other applications. Make it as it's own database with it's own protection and access privs. You'll be happy later on as the wiki catches on and grows.
MikeP
I would like to add a fix to the INSTALL.mysql instructions. (I don't know where else to do this)
Edit the schemas/mysql.sql file if you are going to set config.ini/DATABASE_PREFIX to some value
Continue with the original 3
Leave out the original 4. Edit the config.ini file
DATABASE_TYPE = SQL
DATABASE_DSN = see notes in the config.ini file