Help - Search - Members - Calendar
Full Version: Articles Group Management problems
Invision Power Services > Invision Power Services, Inc. > IPS Company Feedback > IP.Nexus Beta Feedback
jagsfan
i just performed a fresh install of nexus along with the cms beta. everything installs without a hitch, my problem is the article manager. all of the groups display this
Click to view attachment

so i clicked the create it now link and it gives me this error
CODE
mySQL query error: CREATE TABLE  cms_article_fields_data_1 (
                    field_id            INT(10) NOT NULL auto_increment,
                    field_article_id    INT(10) NOT NULL default '0',
                    PRIMARY KEY (field_id),
                    KEY field_article_id (field_article_id)
                );

SQL error: Table 'cms_article_fields_data_1' already exists
SQL error code: 1050
Date: Tuesday 04th of December 2007 07:03:16 PM


i logged into my phpmyadmin and saw that the tables are indeed there. i deleted the first one to see what nexus would do, refreshed my articles group and selected the create it now link again. it says it created the table for the group i had just deleted however it says the same error as the image still. any ideas? im using mysql version 5.0.27-standard

let me add that i have tried deleting all files and re uploading and installing nexus. as well as creating new database, but problem persists.
bfarber
Do you have any prefixes on your tables? Perhaps the tables created are missing the prefix?
jagsfan
excuse me for being a little dumb here bfarber but how would i know that? i have looked through the tables and as far as i can see it all looks ok.
bfarber
Well, when you perform the installation you can specify a table prefix (it's blank by default). What I was suggesting was that potentially you specified a prefix (i.e. "ipn_" like the "ipb_" in IP.Board) but when the tables get created from the ACP it's not using the prefix properly.
xper
Same here. Installed twice in 24 hours. Installed through IP.Nexus installer. No database prefix during install.
jagsfan
got it figured out bfarber thanks! xper maybe this might help. when i create a database on my host named and i name it "ipnexus" it creates the database but adds teamn4_ before it automatically. so now the database is named teamn4_ipnexus, when installing nexus i added the teamn4_ in the prefix setting and proceeded with the install. after install finished i logged in and checked the articles section and it all looks right now! hope that helps xper, thanks again bfarber!
xper
Thanks jagsfan. Works like a charm.
LMarkham
I have the same issue. I am kinda confused a bit. I get the error saying tables arent there and if I create them I get the same message, HOWEVER if I just ignore the visual cue everythign seems to be ok. My database name is mnh_nexus and I specified that for the db name on the install with NO table_prefix. Kinda confusered.... Seems though like its working!
rmnp4ms
I got past the problem by giving the tables a prefix during installation. Hope this helps.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.