Payments versus Deposits part Deux

Password reset isn't working. I think it's a java script error. When I'm tring to install the PBook database I'm getting an error "cannot open ./apps/pbooks/data/sample_data/auth_pbooks_data.sql: no such file. I looked in the file I downloaded and I can't find that file?

Tom

Looks like an error, that file has been combined with the demo_pbooks_data.sql:

http://www.pbooks.org/trac/browser/trunk/apps/pbooks/data/sample_data/demo_pbooks_data.sql

You were right, the install_db.php file was referencing the wrong file, its been fixed and is in the repository.

Thanks - I think I going to do a clean install. I just need to go to the download page and redownload .012 right? Tom

Actually, you'd be better off with the code right from subversion. Do you know how to use subversion?

I've never done it before. But it looks like click on the file,(just install_db.php in this case) and download the file and replace the file on my install machine?

Tom

Ok - I downloaded the install file, deleted the datatbase, and reran the install. I'm getting the error below now:

ERROR 1005 (HY000) at line 119: Can't create table './pbooks/#sql-1028_31.frm' (errno: 121)

ps - if you want to move this thread to the to PBooks 0.12 thread I'll start looking there.

Thanks again,
Tom

Do you have phpmyadmin installed? I've just posted a SQL statement which will import into a fresh database without error:

http://www.pbooks.org/wiki/SQL_Dump_of_PBooks_Database

OK - that worked like a charm. I deleted the old database. Created a new one and ran the script. All created. Next I tried to log in and I'm getting the message below. I have pear installed and I followed the two steps to install Nexista. I looked for the missing folder and file and its not on my machine?

I know I'm getting close.

Tom

Warning: include(/var/www/dev/nexista/extensions/nexista_builder.php) [function.include]: failed to open stream: No such file or directory in /usr/share/pbooks/web/auth.php on line 29

Warning: include() [function.include]: Failed opening '/var/www/dev/nexista/extensions/nexista_builder.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/share/pbooks/web/auth.php on line 29
Error: Unable to load server loader or builder.

Ah OK, yes you are close. Where do you have Nexista installed? If its in the same directory as pbooks, just change auth.php to read:

define('NX_PATH_BASE', "../nexista/");

at the very beginning.

Oh wait I just re-read your message and notice that you have nexista installed, but not the extensions folder. Is that correct?

Here's what your nexista folder should look like:

http://www.nexista.org/svn/nexista/trunk/

Correct, my directory does not look like that. I've looked looked all over trying to fines the extendion. Could you post a lib for the nexista extension download.

Thanks

Tom

I think I figured 90% of this out. When I enter:

svn co http://www.nexista.org/svn/nexista/trunk/nexista nexista

as posted on the nexista site I get an error message stating that:

svn: URL 'http://www.nexista.org/svn/nexista/trunk/nexista' doesn't exist

But . . when I enter:
svn co http://www.nexista.org/svn/nexista/trunk

The extensions get downloaded to the current directory. So . . .

Where should the nextista directory be located on my machine? I tried reinstalling nexista it and I get a message stating that it's already installed. So I beleive the install is ok. I just need the extenstions.

Thanks again,

Tom

Hi TomP, Nexista can be installed in the same directory as Pbooks. Where do you have Pbooks located? I'm going to roll out another Nexista release, as a lot has been updated since the last release.

You are right about the svn co command, here's some more specifics:

http://www.pbooks.org/wiki/PBooks_Installation_on_Debian

Ubuntu and debian are very similar.

Also TomP - can you let me know which browser you are using so I can debug the forums javascript?

And if you want to schedule a time to go through the install, I'd be happy to make sure you are able to get PBooks operational.

Hi TomP, You can get fresh nexista packages here:

http://www.nexista.org/pub/

Uncle . . .
I think that I've hacked this bad enough that if I did get it running I'd never know why. The real fatal error I made was not taking a snap shot before I started messing around. I'm on vacation this week and next week. I'll contact you when I have a clean system. I don't have anything else running on Ubuntu so it's no big deal.

Thanks you so much for all your help with this,

Tom

Happy Holidays Tom, thanks for your interest in PBooks!

I just couldn't stay away. Learning lots by doing this. I built a brand new Ubuntu VM. I did a clean pbooks install following the Debian instructions, no hacking. Below are my notes:

1.Installed LAMP
2.Installed phpMyAdmin
3.Use Synaptic to install Subversion and Subversion-Tools because I received an error on the svn command.
4.Installed pear
sudo apt-get install php-pear
5.Followed Here are the commands I use to install the requirements:
6.Followed PBooks Code Installation on the second to last step:
cd /opt/lampp/htdocs (I received a directory not found. I have a /opt directory. But I do not have an /opt/lampp/htdocs directory) I looked at the INSTALL file and did a cd /var/www/. Then continued.
7.To create the database I created a database using phpmyadmin called pbooks and ran the script located at: http://www.pbooks.org/wiki/SQL_Dump_of_PBooks_Database using the SQL tab.
8.Tried to log in using http://localhost/pbooks/auth.php?nid=login
Warning: include(/usr/share/pbooks/nexista//plugins/builder.php) [function.include]: failed to open stream: No such file or directory in /usr/share/pbooks/web/auth.php on line 19

Warning: include() [function.include]: Failed opening '/usr/share/pbooks/nexista//plugins/builder.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/share/pbooks/web/auth.php on line 19
Error: Unable to load server loader or builder.
9.Note the // this looks like a configuration problem in auth.php. mmmmmm
I changed the line:
$nexista_path = "/usr/share/pbooks/nexista/";

to read
$nexista_path = "/usr/share/pbooks/nexista";

1.Same type of error:
Warning: include(/usr/share/pbooks/nexista/plugins/builder.php) [function.include]: failed to open stream: No such file or directory in /usr/share/pbooks/web/auth.php on line 19

Warning: include() [function.include]: Failed opening '/usr/share/pbooks/nexista/plugins/builder.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/share/pbooks/web/auth.php on line 19
Error: Unable to load server loader or builder.

I got to believe I'm real close . . .

Anyway - have a happy holiday,

Tom

Albert - What's the best way for us to setup a time get pBooks up and running? I'm on vacation until 1/5/09 so my date/time is pretty flexable. I'm located in the NY area (EST).

Thanks again,

Tom

Hi Tom, I'm available right now if you are. I'm in the Boston area right now so we're in the same time zone.

I just emailed you, can we work together on the pbooks mailing list?