Help Please on Install

stuartn · September 13th, 2004, 03:17 PM

I bought this software on the basis that it would intergrate with Nuke as advertised......

However, I'm slowing starting to feel that this isn't exactly true.....

I've been through this install so many times its doing my head in...

I put in my database info on the top, then again as it suggests if intergrating with an existing registration system. I make the prefix nuke_ as the rest of the tables are.

Then it updates the config file, fine.....

Click on the link for external registration system

I've tried Nuke and Post Nuke

I've then filled in the relvant details for URL info

Then I get this

Quote:

MySQL error reported!

Script: install

Query: SELECT pn_gid,pn_name FROM groups

Result: Table 'raptor28_test.groups' doesn't exist

Database handle: Resource id #12

Also this at the top of the page

Quote:

Warning: file_exists(): open_basedir restriction in effect. File(/path/to/php/headtags.htm) is not within the allowed path(s): (/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/lib/php:/usr/local/mysql/bin:/usr/local/share/pear:/pub/home/raptor28) in /pub/home/raptor28/htdocs/subdomain/pp-classifieds/pp-inc.php on line 245

Warning: file_exists(): open_basedir restriction in effect. File(/path/to/php/header.htm) is not within the allowed path(s): (/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/lib/php:/usr/local/mysql/bin:/usr/local/share/pear:/pub/home/raptor28) in /pub/home/raptor28/htdocs/subdomain/pp-classifieds/pp-inc.php on line 318

I get the security announcement for the install, so fine I delete it......

Now I have this one...

Quote:

MySQL error reported!

Script: index

Query: SELECT pn_uid,pn_uname,pn_email,pn_pass,pn_timezone_offset FROM users WHERE pn_uid='-1'

Result: Table 'raptor28_test.users' doesn't exist

Database handle: Resource id #7

Where do I go from here.......Please I need some help here.....

Michael P · September 13th, 2004, 04:04 PM

When you set your configuartion items, did you set the user database to your Nuke DB properly? The script cannot seem to find the Nuke database structure to import the usergroups or access the users table.

stuartn · September 13th, 2004, 04:52 PM

See below table list

Quote:

nuke_admingroups 11 MyISAM 2.3 KB
nuke_admlog 0 MyISAM 1.0 KB
nuke_adtypes 4 MyISAM 3.1 KB
nuke_authors 1 MyISAM 3.1 KB
nuke_autonews 0 MyISAM 1.0 KB
nuke_banner 0 MyISAM 1.0 KB
nuke_bannerclient 0 MyISAM 1.0 KB
nuke_bbauth_access 0 MyISAM 1.0 KB
nuke_bbbanlist 0 MyISAM 1.0 KB
nuke_bbcategories 0 MyISAM 1.0 KB
nuke_bbconfig 61 MyISAM 4.6 KB
nuke_bbdisallow 0 MyISAM 1.0 KB
nuke_bbforum_prune 0 MyISAM 1.0 KB
nuke_bbforums 0 MyISAM 1.0 KB
nuke_bbgroups 2 MyISAM 3.1 KB
nuke_bbposts 0 MyISAM 1.0 KB
nuke_bbposts_text 0 MyISAM 1.0 KB
nuke_bbprivmsgs 0 MyISAM 1.0 KB
nuke_bbprivmsgs_text 0 MyISAM 1.0 KB
nuke_bbranks 2 MyISAM 2.1 KB
nuke_bbsearch_results 0 MyISAM 1.0 KB
nuke_bbsearch_wordlist 0 MyISAM 1.0 KB
nuke_bbsearch_wordmatch 0 MyISAM 1.0 KB
nuke_bbsessions 4 MyISAM 4.2 KB
nuke_bbsmilies 44 MyISAM 3.6 KB
nuke_bbthemes 1 MyISAM 2.3 KB
nuke_bbthemes_name 1 MyISAM 3.5 KB
nuke_bbtopics 0 MyISAM 1.0 KB
nuke_bbtopics_watch 0 MyISAM 1.0 KB
nuke_bbuser_group 2 MyISAM 3.0 KB
nuke_bbvote_desc 0 MyISAM 1.0 KB
nuke_bbvote_results 0 MyISAM 1.0 KB
nuke_bbvote_voters 0 MyISAM 1.0 KB
nuke_bbwords 0 MyISAM 1.0 KB
nuke_blocks 16 MyISAM 5.9 KB
nuke_categories 2 MyISAM 3.1 KB
nuke_comments 0 MyISAM 1.0 KB
nuke_config 1 MyISAM 2.2 KB
nuke_confirm 0 MyISAM 1.0 KB
nuke_contactbook 0 MyISAM 1.0 KB
nuke_counter 19 MyISAM 1.4 KB
nuke_downloads_categories 0 MyISAM 1.0 KB
nuke_downloads_downloads 0 MyISAM 1.0 KB
nuke_downloads_editorials 0 MyISAM 1.0 KB
nuke_downloads_modrequest 0 MyISAM 1.0 KB
nuke_downloads_newdownload 0 MyISAM 1.0 KB
nuke_downloads_votedata 0 MyISAM 1.0 KB
nuke_encyclopedia 0 MyISAM 1.0 KB
nuke_encyclopedia_text 0 MyISAM 1.0 KB
nuke_ephem 0 MyISAM 1.0 KB
nuke_faqAnswer 0 MyISAM 1.0 KB
nuke_faqCategories 0 MyISAM 1.0 KB
nuke_favorites 0 MyISAM 1.0 KB
nuke_groups 0 MyISAM 1.0 KB
nuke_groups_points 21 MyISAM 2.2 KB
nuke_headlines 29 MyISAM 4.7 KB
nuke_ipcache 0 MyISAM 1.0 KB
nuke_iponline 1 MyISAM 2.1 KB
nuke_journal 0 MyISAM 1.0 KB
nuke_journal_comments 0 MyISAM 1.0 KB
nuke_journal_stats 0 MyISAM 1.0 KB
nuke_laston 0 MyISAM 1.0 KB
nuke_links_categories 0 MyISAM 1.0 KB
nuke_links_editorials 0 MyISAM 1.0 KB
nuke_links_links 0 MyISAM 1.0 KB
nuke_links_modrequest 0 MyISAM 1.0 KB
nuke_links_newlink 0 MyISAM 1.0 KB
nuke_links_votedata 0 MyISAM 1.0 KB
nuke_main 1 MyISAM 1.0 KB
nuke_message 1 MyISAM 3.6 KB
nuke_modules 26 MyISAM 7.9 KB
nuke_notify 0 MyISAM 1.0 KB
nuke_pages 0 MyISAM 1.0 KB
nuke_pages_categories 0 MyISAM 1.0 KB
nuke_poll_check 0 MyISAM 1.0 KB
nuke_poll_data 12 MyISAM 1.7 KB
nuke_poll_desc 1 MyISAM 3.1 KB
nuke_pollcomments 0 MyISAM 1.0 KB
nuke_popsettings 0 MyISAM 1.0 KB
nuke_priv_msgs 0 MyISAM 1.0 KB
nuke_products 0 MyISAM 1.0 KB
nuke_public_messages 0 MyISAM 1.0 KB
nuke_queue 0 MyISAM 1.0 KB
nuke_quotes 1 MyISAM 3.0 KB
nuke_referer 0 MyISAM 1.0 KB
nuke_related 0 MyISAM 1.0 KB
nuke_reviews 0 MyISAM 1.0 KB
nuke_reviews_add 0 MyISAM 1.0 KB
nuke_reviews_comments 0 MyISAM 1.0 KB
nuke_reviews_main 1 MyISAM 1.1 KB
nuke_seccont 0 MyISAM 1.0 KB
nuke_sections 0 MyISAM 1.0 KB
nuke_session 1 MyISAM 3.1 KB
nuke_settings 86 MyISAM 9.8 KB
nuke_sort 6 MyISAM 2.3 KB
nuke_stats_date 366 MyISAM 5.6 KB
nuke_stats_hour 216 MyISAM 3.1 KB
nuke_stats_month 12 MyISAM 1.1 KB
nuke_stats_year 1 MyISAM 1.0 KB
nuke_stories 0 MyISAM 1.0 KB
nuke_stories_cat 0 MyISAM 1.0 KB
nuke_subscriptions 0 MyISAM 1.0 KB
nuke_topics 1 MyISAM 3.0 KB
nuke_usergroups 2 MyISAM 2.1 KB
nuke_users 19 MyISAM 9.1 KB
nuke_users_temp 0 MyISAM 1.0 KB

"raptor.test" isn't the prefix for the table..."nuke_", is....and I keep putting in nuke as the prefix.

stuartn · September 14th, 2004, 11:18 AM

I'm still in need of some help here......any takers :-)

Chuck S · September 14th, 2004, 03:04 PM

In your photopost database settings table what does setting 83 read?

It should read nuke_

stuartn · September 14th, 2004, 05:22 PM

Quote:

83 Forum database table prefix dprefix 14 1

I'm presuming the prefix here isn't right, should I change it too nuke_

Chuck S · September 14th, 2004, 05:33 PM

yes the setting should be nuke_

stuartn · September 14th, 2004, 05:46 PM

Okay now I'me getting somewhere, were in......

But I still have this at the top of the page.

Quote:

Warning: file_exists(): open_basedir restriction in effect. File(/path/to/php/headtags.htm) is not within the allowed path(s): (/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/lib/php:/usr/local/mysql/bin:/usr/local/share/pear:/pub/home/raptor28) in /pub/home/raptor28/htdocs/subdomain/pp-classifieds/pp-inc.php on line 245

Warning: file_exists(): open_basedir restriction in effect. File(/path/to/php/header.htm) is not within the allowed path(s): (/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/lib/php:/usr/local/mysql/bin:/usr/local/share/pear:/pub/home/raptor28) in /pub/home/raptor28/htdocs/subdomain/pp-classifieds/pp-inc.php on line 318

stuartn · September 14th, 2004, 05:50 PM

Ohhh and I'm not a recognised moderator or administrator

Chuck S · September 14th, 2004, 08:31 PM

You need to remove from the settings table since you arent recognized as admin the bogus paths to headtags.htm and footer.htm etc

Check your photopost usergroups table. I beleive nuke uses phpbb as the forum so you should have an admin id of 2 I beleive

INSERT INTO {$pp_db_prefix}usergroups VALUES ('1','Anonymous',0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO {$pp_db_prefix}usergroups VALUES ('2','Admin',1,1,1,0,0,1,1,1,1,0,0);

check to make sure cpaccess is set to 1

stuartn · September 15th, 2004, 06:44 PM

The two pieces at the top are now gone, I've checked the usergroups and it matches what you've said, but still I have no access to the admin....

Chuck S · September 15th, 2004, 06:51 PM

where is your install? and PM a login

Chuck S · September 15th, 2004, 09:28 PM

I bet I know your issue

You have a SUPER ADMIN ACCOUNT but never choose the option to also elect to make it board user.

I registered an account and your usergroups settings are fine for regular user so the only issue I can think of is that. Try creating a secondary account and making it admin account

stuartn · September 16th, 2004, 03:35 AM

Do you mean regisiter myself as another user and within Nuke set that user with admin or alter the tables in some way......

Chuck S · September 16th, 2004, 08:11 AM

Ok when an admin first sets up Nuke they have the option to make a super admin user and regular admin user. You only made the super admin user. We integrate with phpbb really within Nuke so in essense your user is not there I beleive. Create another to use as an admin on the forum and gallery

stuartn · September 16th, 2004, 08:39 AM

I'm setup on nuke with a user and admin access, I can log into nuke just stand alone and then log into admin.

stuartn · September 17th, 2004, 07:24 AM

Still no further forward.....where do I go from here.....

Chuck S · September 17th, 2004, 07:39 AM

I dont know what you mean here? Did you do my suggestion?

Make the user Omegatron in nuke an admin and let me see if I can access it

stuartn · September 17th, 2004, 08:58 AM

done.....

I have two users, super and normal and neither can get in.

Chuck S · September 17th, 2004, 11:03 AM

I cant help you if you continue to not do what I ask?

I have a user Omegatron on your forum that I asked for you to promote to admin on the forum.

Stuartn which does not have the password you send which is wrong is in some non-member group

As I stated if when you originally made your super user if you did not check the box to also create that account on the forum there is not much I can do. You need to create an additional id on the forum and make them admin.