Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 05:09 am EDT

Geeklog Forums

projects plugin won't install.


Status: offline

tt0ne

Forum User
Chatty
Registered: 03/29/04
Posts: 58
When I go to the plugin panel and click on install it says:

Installation Failed -- See your error log to find out why.

The Plugin is Not Installed

Ok, here is the error in my logs:

Tue 15 Jun 2004 06:39:52 PM EDT - Attempting to install the projects Plugin
Tue 15 Jun 2004 06:39:52 PM EDT - Creating table1 table
Tue 15 Jun 2004 06:39:52 PM EDT - 1064: You have an error in your SQL syntax near 'PRIMARY KEY (uid, proj_id)) TYPE=MyISAM' at line 1. SQL in question:
Tue 15 Jun 2004 06:39:52 PM EDT - Error Creating table1 table
Tue 15 Jun 2004 06:39:52 PM EDT - Attempting to unregister the projects plugin from Geeklog
Tue 15 Jun 2004 06:39:52 PM EDT - Removing Table gl_projects
Tue 15 Jun 2004 06:39:52 PM EDT - Removing projects Admin Group
Tue 15 Jun 2004 06:39:52 PM EDT - Removing root users from admin of projects
Tue 15 Jun 2004 06:39:52 PM EDT - Removing projects.admin feature and rights to it
Tue 15 Jun 2004 06:39:52 PM EDT - Removing projects.view feature and rights to it
Tue 15 Jun 2004 06:39:52 PM EDT - ...success

Any ideas?

Thanks!

Marco Belmonte (HeavenlySanctuary.com)
HeavenlySanctuary.com - "Surf The Innernet!"
 Quote

Status: offline

tt0ne

Forum User
Chatty
Registered: 03/29/04
Posts: 58
Should I post this on the person who wrote this page? This doesn't look like a plugin that many people are really using...


HeavenlySanctuary.com - "Surf The Innernet!"
 Quote

Status: offline

dick

Forum User
Junior
Registered: 05/31/04
Posts: 23
Exact same problem here. Did you ever get it resolved?
 Quote

Status: offline

tt0ne

Forum User
Chatty
Registered: 03/29/04
Posts: 58
Nope, never did.

Does the author frequent this forum???

Help man! ;-)

- Marco
HeavenlySanctuary.com - "Surf The Innernet!"
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
There is a newer version avalible but it has not been approved yet, and it fixes the issue. That said my site is www.thomassoft.net and I check both site quite often.

Not many people are using it becuase its only 2 weeks old and in development still hehe.
 Quote

Status: offline

tt0ne

Forum User
Chatty
Registered: 03/29/04
Posts: 58
Thanks, man. I'll go check it out!

- Marco
HeavenlySanctuary.com - "Surf The Innernet!"
 Quote

Status: offline

tt0ne

Forum User
Chatty
Registered: 03/29/04
Posts: 58
Just tried to install your new version. Here is what I get in my error log:

Thu 17 Jun 2004 05:47:54 PM EDT - Attempting to install the projects Plugin
Thu 17 Jun 2004 05:47:54 PM EDT - Creating table1 table
Thu 17 Jun 2004 05:47:54 PM EDT - 1064: You have an error in your SQL syntax near 'PRIMARY KEY (uid, proj_id)) TYPE=MyISAM' at line 1. SQL in question:
Thu 17 Jun 2004 05:47:54 PM EDT - Error Creating table1 table
Thu 17 Jun 2004 05:47:54 PM EDT - Attempting to unregister the projects plugin from Geeklog
Thu 17 Jun 2004 05:47:54 PM EDT - Removing Table gl_projects
Thu 17 Jun 2004 05:47:54 PM EDT - Removing projects Admin Group
Thu 17 Jun 2004 05:47:54 PM EDT - Removing root users from admin of projects
Thu 17 Jun 2004 05:47:54 PM EDT - Removing projects.admin feature and rights to it
Thu 17 Jun 2004 05:47:54 PM EDT - Removing projects.view feature and rights to it
Thu 17 Jun 2004 05:47:54 PM EDT - ...success

Any ideas?

- Marco
HeavenlySanctuary.com - "Surf The Innernet!"
 Quote

Status: offline

dick

Forum User
Junior
Registered: 05/31/04
Posts: 23
Tried the newest build that I saw was updated the 16th the morning of the 17th.

same deal.

Its gotta suck to try to debug a issue that works fine on your own machine.
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
Ok Take 3 , try again
Update on thomassoft.net

Thanks
 Quote

Status: offline

dick

Forum User
Junior
Registered: 05/31/04
Posts: 23
I was feeling so optimistic about this one too.


Text Formatted Code
Wed 16 Jun 2004 01:20:09 PM EDT - Attempting to install the projects Plugin
Wed 16 Jun 2004 01:20:09 PM EDT - Creating table1 table
Wed 16 Jun 2004 01:20:09 PM EDT - 1064: You have an error in your SQL syntax near 'PRIMARY KEY  (uid, proj_id)) TYPE=MyISAM' at line 1. SQL in question:  
Wed 16 Jun 2004 01:20:09 PM EDT - Error Creating table1 table
Wed 16 Jun 2004 01:20:09 PM EDT - Attempting to unregister the projects plugin from Geeklog
Wed 16 Jun 2004 01:20:09 PM EDT - Removing Table gl_projects
Wed 16 Jun 2004 01:20:09 PM EDT - Removing projects Admin Group
Wed 16 Jun 2004 01:20:09 PM EDT - Removing root users from admin of projects
Wed 16 Jun 2004 01:20:09 PM EDT - Removing projects.admin feature and rights to it
Wed 16 Jun 2004 01:20:09 PM EDT - Removing projects.view feature and rights to it
Wed 16 Jun 2004 01:20:09 PM EDT - ...success

 
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
Well...
Questions for you then.
What version PHP
What version MySql
What OS (Windows, Linux/OSX, etc..)
 Quote

Status: offline

dick

Forum User
Junior
Registered: 05/31/04
Posts: 23
Database:

MySQL 3.23.58

Server Date:

2004-06-16 13:36:52

Database Date:

2004-06-16 13:36:52

Web Server:

Apache/2.0.40 (Red Hat Linux)

PHP Version:

4.2.2 (Zend Vers: 1.2.0)
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
I'm not sure if this is the issue or not but I'm using MySql 4.0 and PHP 4.3.7.

So this is what we'll do I was already planning on leaving the default install method behind do to ...mm issues I keep having with it.

I'm going to modify the install.php file today adn see what I can tweak.

We should be able to pin-point the error a bit better tho it may not occur again once this is written :-)
 Quote

Status: offline

dick

Forum User
Junior
Registered: 05/31/04
Posts: 23
no problemo.
I'm all for further debugging if you are willing to put up with my witty reparte every time it doesnt work. If the system will be better, I am in no hurry and can help in any way you may require.
Thanks for looking into the issue. Its nice to be able to see somebody trying, rather then ignoring or pointing blame.
 Quote

Status: offline

dick

Forum User
Junior
Registered: 05/31/04
Posts: 23
Thomassoft.net shows the last update was on 6.17.04. Just checking in to see if you made any progress or changes.
 Quote

All times are EDT. The time is now 05:09 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content