View Full Version : Table '*.user_preferences' doesn't exist
boommedia
31-05-04, 02:40 AM
Hi,
after completing installation, I've tried to login to the DotProjet interface, however, I having this error:
Table '*.user_preferences' doesn't exist
So, I've search the Forum and the FAQ and it seems a couple of people have the same problem but on temporary tables.
So my question is: Is the user_preference table a temporary table :oops: and if not, what can I do to fix the problem :? ?
Of course, all the settings like the user_db and its permissions are correctly granted.
Thank you,
Dan :)
i'm having the same problem. anyone have any suggestions?
Prabhakar
27-07-04, 02:59 PM
Hello
User_Preferences table is not a temporary table, have you tried to connect your mysql database using any of interfaces like mysql control center (console manager) and there you can find all the tables used in DP.
i suggest you to re-install it.
it actually doesn seem like any tables have been created (seen via myphpadmin). i don't know much about sql databases at all, so this installation is a bit hard for me to troubleshoot - also since there isn;t an installer.
would this have anything to do with this part of the installation -
"#mysql -udotproject -pyourpassword dotproject < dotproject/db/dotproject_{version}.sql* "
can anyoen help with this installation problem? i'd really like to use dotproject, but installation has been a bit problematic.
ajdonnison
29-07-04, 10:27 AM
Try grabbing the current CVS version, which DOES have an installer. Point your browser to dotproject/install and follow the bouncing ball.
1.0.2-1 still doesn't seem to have an installer. what am i missing here???
The last release is not the CVS.
sorry for the ignorance, but what does that mean?
The CVS is the ongoing development base - the last release is the snapshot of the CVS that was taken back in March.
Search here and on sourceforge if you don't know how to access the CVS.
ok, i think the problem here is that i have not propagated the database yet. i believe i have everythign else set up correctly. i've tried entering the command into myphpadmin but, there are no tables created after doing so. is there another way to do this? is database propagation automated anywhere?
forgive me, but i've never worked with sql commands before. every time i try it seems to accept the command but does not remedy the problem.
Here are some tips that might help:
1. Open phpMyAdmin in your browser.
2. If your ISP allows you to create a new database then do so.
3. Write down the name of your database, username, and password.
4. Select your new database from the list on the left of phpMyAdmin.
5. Select the SQL tab.
6. Click the browse button.
7. Provided you decompressed dotProject on your local machine, navigate to /dotproject/db and select dotproject.sql
8. Press Go.
You should now see the dotproject.sql script execute and your tables will have been created.
The reason it is important to write down your username, database, and password is because you will now need to edit /dotproject/includes/config.php. You will be editing the following lines which are close to the top of the script and right under DATABASE ACCESS INFORMATION.
$dPconfig['dbtype'] = "mysql";
$dPconfig['dbhost'] = "localhost";
$dPconfig['dbname'] = "your_database";
$dPconfig['dbuser'] = "your_username";
$dPconfig['dbpass'] = "your_password";
$dPconfig['dbport'] = "3306";
Some other important configs to edit are located under "local settings". Here is an example from my local machine that's running Windows XP.
$dPconfig['root_dir'] = "E:/Program Files/Apache Group/Apache2/htdocs/dotproject_cvs";
$dPconfig['company_name'] = "Pitney Bowes Management Services";
$dPconfig['page_title'] = "CRFP Project Management";
$dPconfig['base_url'] = "http://localhost/dotproject_cvs";
$dPconfig['site_domain'] = "dotproject_cvs"; //dotproject.net
My site_domain setting may be wrong but is not an issue because I changed my site style and don't use it for anything.
Once that is done, you should probably run check.php from your browser. It is located in http://yoursite/docs/check.php. This will let you know if you have things set up properly.
Now you should be ready to run dotproject. Type http://yoursite/index.php and it should work. Of course your path may be slightly different depending on where you installed dotProject.
Hope that helps.
--zbert
The CVS is the ongoing development base - the last release is the snapshot of the CVS that was taken back in March.
Am I understanding you correctly? The Download CVS Snapshot is from March and, if I want to grab the most current CVS snapshot, I should do so at Sourceforge. In your opinion, is the current CVS in pretty decent shape? Is at any more or less stable than the March snapshot. I'd really like to use the latest code but it has to be pretty stable for the most part. I want to put up a production system at work and a load of people will be using it.
Any recommendations?
Thanks, zbert.
that worked like a charm. thank you zbert!
cyberhorse
16-08-04, 09:15 AM
I think the cvs version is in a pretty decent state - I use it every day. However there might be problems that we have overseen, but if so it is still good using it so you can warn us about them and they can be fixed before the release.
I thought the CVS snapshot is done daily, or at least quite frequently?!
ajdonnison
16-08-04, 09:22 AM
The CVS is the ongoing development base - the last release is the snapshot of the CVS that was taken back in March.
Am I understanding you correctly? The Download CVS Snapshot is from March and, if I want to grab the most current CVS snapshot, I should do so at Sourceforge.
No you are not understanding at all. The CVS snapshot link gives a snapshot of the current development tree (the CVS) as at last night. A release is a snapshot of the CVS taken at a point in time and frozen as a release. The last release was done in March, hence it was a snapshot of the CVS at that time. The Download dotProject link gives you the last release, as at March. The Download CVS snapshot gives you the current development tree, always no more than 24 hours old.
In your opinion, is the current CVS in pretty decent shape? Is at any more or less stable than the March snapshot. I'd really like to use the latest code but it has to be pretty stable for the most part. I want to put up a production system at work and a load of people will be using it.
CVS snapshot comes with no warranty. You can try it but if it breaks, don't complain.
ajdonnison
16-08-04, 09:47 AM
Snapshot is supposed to run daily via a cron job, however Sourceforge have disabled cron due to performance problems, so it gets done when I remember it. Usually it is done Monday to Friday business hours Australian Eastern Standard Time. (10 hours East of GMT).
cyberhorse
16-08-04, 07:07 PM
CVS snapshot comes with no warranty. You can try it but if it breaks, don't complain.
Well, feel free to complain, but don't hold it against us - it's work in progress :)
Thanks guys. Don't get me wrong, I'm not complaining. Just reporting some errors that I thought I might be able to track down and resolve. I'll have to revisit the bug tracker and report there.
Do you not experience the same tab problem with the current snapshot? It is happening to me on two different systems, Linux and WinXP. I deleted cookies and cleared my cache but no luck.
--zbert
ajdonnison
16-08-04, 09:56 PM
Now you have confused me. You haven't mentioned a problem with tabs in this thread, what are you talking about? If it is from another thread, follow it up there, otherwise everyone will just end up more confused than enlightened. This thread is about not loading the initial database schema.
Now you have confused me.
:oops: I am so sorry. I posted my reply to the wrong thread. Hope you don't think I am a complete idiot!
--zbert
vBulletin® v3.6.4, Copyright ©2000-2013, Jelsoft Enterprises Ltd.