Not Loaded

Worker Joined: Dec 05, 2006 Posts: 180

While Loading the Core tables, it shows not loaded, but they appear loaded in mysql. I have not loaded any other tables yet. Prob will here after i post.

Php 5.1.4
Mysql 5.0.22

Edit: Ok other tables seem to show loaded.

Edit: After loading other tables that appear to load from the installer( show loaded) and going to setup, I get an error saying im missing my nuke_config table and can not complete setup.

Error:Unable to Update nuke_config table. MySQL reported: Table '<<removed by admin>>.nuke_config' doesn't exist

Posted: Sun Mar 11, 2007 10:33 pm

I don't understand, if they are loaded, then nuke_config should exist. Are you looking at the correct database?

Posted: Sun Mar 11, 2007 10:37 pm

sorry only 39 tables were loaded. I guess all the ones to nuke_cities? that is the last and nuke_authors is the first.

Posted: Sun Mar 11, 2007 11:29 pm

I have no clue what im doing i guess. I edited the core sql file, so that _config is at the top. Well it loads now. Also the rest from _authors to _cities, but from after _config, if you were to look at the original file, other tables starting from _confirm do not load.

Posted: Mon Mar 12, 2007 12:40 am

Eh i dont know...

I got it to work by editing the core.sql file Changing all $prefix to nuke_ then um not sure what you call it, populated the database. Then ran the rest of the installSQL.php.

All seems to work and WOW!~ is it fast

Posted: Mon Mar 12, 2007 6:42 am

jjh221, that is odd. Are you sure that you had the $prefix variable in your config.php file set correctly? This has worked over 100 times for me....

Posted: Mon Mar 12, 2007 8:19 am

I have tried jjh221s suggestion to change the $prefix. to nuke_ and it loads for me to 89 tables until I get this error message from mysql:

Error
SQL query:

INSERT INTO `nuke_users`
VALUES ( 1, '', 'Anonymous', '', '', '', 'blank.gif', 'Nov 10, 2000', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, NULL , 'english', 'D M d, Y g:i a', 0, 0, 0, NULL , 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL , NULL , NULL , 0, '0' ) ;

MySQL said:

#1136 - Column count doesn't match value count at row 1

This is on my local xampp install. MySQL client version: 5.0.27 I still am fighting install issues......any suggestions would be greatly appreciated.... Very Happy

Posted: Mon Mar 12, 2007 8:33 am

Are you sure you have the right version??? There was a problem with the $prefix in an earlier 2.02 version but not in the 2.10 version.

The other problem, having it stop in the middle of the cities table ... I'm wondering if you could be running into a resource limit issue on your server. You don't use Ipowerweb by any chance? The cities is a huge table and you could be hitting their infamous max resources limit if that's the case.

Posted: Mon Mar 12, 2007 10:19 am

fkelly, if you were talking to me as far as the correct version, yes it is. I downloaded the released version as soon as it was available. I will do it again just to make sure. The 2.02 version installs for me just fine. It is anything since then that gives me errors..... Smile

Posted: Mon Mar 12, 2007 10:26 am

Fire, I wasn't quite sure who was having what problems in this thread. A couple of the issues in your post just looked similar to what had happened with earlier versions of 2.02 so I asked the question. I KNOW that the current version of installSQL.php substitutes in the $prefix variable from your config.php file and I know that was a problem in an earlier release if you had something other than "nuke" as a prefix.

Posted: Mon Mar 12, 2007 11:13 am

montego, Yep i think, I can set any prefix variable i choose, right? Perhaps ill try it with what it comes with.

fkelly, This might be an issue but i dont know exactly what a resource limit is. Im using a windows system here. It just seems that it stops or hangs up after cities, while trying to use the installSQL.php.

FireATST, Not sure what that error is. I can send you the core file i used.

Posted: Mon Mar 12, 2007 11:41 am

jjh221The resource limit that I was referring to was a maximum number of queries limit that Ipowerweb imposes per user in a specific period of time. However, there can also be CPU limits and I've seen problems on my own Windows systems trying to load the tables. I can't be sure if that's what your problem is though. If it is, and if you have access to your php.ini file you might want to find the maximum execution time and the maximum input time settings in there and give them a very substantial boost. Then you might need to stop and restart your web server to have the new settings take effect.

Posted: Mon Mar 12, 2007 1:20 pm

fkelly wrote:

jjh221The resource limit that I was referring to was a maximum number of queries limit that Ipowerweb imposes per user in a specific period of time. However, there can also be CPU limits and I've seen problems on my own Windows systems trying to load the tables. I can't be sure if that's what your problem is though. If it is, and if you have access to your php.ini file you might want to find the maximum execution time and the maximum input time settings in there and give them a very substantial boost. Then you might need to stop and restart your web server to have the new settings take effect.

YAY! it was the Resource Limits.

Thanks Kelly Very Happy

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

FireATST,

Something is amiss and I think it's local to you. I have installed and reinstalled countless times and I don't receive any erors.

Posted: Mon Mar 12, 2007 2:02 pm

Thanks fkelly, I am using the default nuke prefix that is in the config file. I will try this again with the newly downloaded core sql and see if swapping the nuke_ for $prefix works.

Raven, it maybe something locally I don't know. That is what I have been trying to figure out for a while now. The webhost I use is bluehost and when I attempt to install the beta version I had same problem. Your work arounds you posted in the bugtracker worked for me then. I will try and re-install the latest public release when I can on the webhost to see if one, it gives me the mysql error with no explaination, and 2, if the work arounds you gave earlier will work to install the public version on my webhost if I do get the error with mysql. I want to upgrade my production site to 2.10 but I would like to make sure of anything I need to change doing it locally first. I have several 3rd party modules and stuff on production site that I would like to keep in 2.10. If I can get them running locally first I think it would be less stressful on me...... Very Happy

My local install is on standard xampp (the latest I believe). I have not changed any configuration on it since install. I think I have seen someone (maybe Montego, don't remember for sure) state using the xampp for local testing. Not sure if there is something I must adjust on the xampp install to get it to install or not. That is what I am trying to figure out lately. But if I can't get it to install correctly on the webhost either, than I think I would tend to believe it isn't just a local problem. I will try and do that later tonight or Wednesday.

Posted: Mon Mar 12, 2007 4:08 pm

Keep us posted (I'm sure you will Laughing

). Just as an FYI, I am using XAMPP also as so many are using it. What pleasantly surprised me is that RavenNuke(tm) installed w/o any issues and seems to be working under MySQL 5.x and PhP 5.x! We may have to revise our documentation Smile

Posted: Mon Mar 12, 2007 5:54 pm

You know Raven....I am sensing hostility from you. I am just advising you as to what I am having trouble with. I let you know what my setup was in hopes it might help you to help me. I really like the Raven nuke distros and the people here, but I won't be insulted by you or anyone else. You think I come here to harass you? I was just trying to find help to my situation....thanks.

Posted: Mon Mar 12, 2007 6:33 pm

lol i dont think he is insulting you. He is most likely supporting you and your error.

:shrugs:

Posted: Mon Mar 12, 2007 6:45 pm

FireATST wrote:

You know Raven....I am sensing hostility from you. I am just advising you as to what I am having trouble with. I let you know what my setup was in hopes it might help you to help me. I really like the Raven nuke distros and the people here, but I won't be insulted by you or anyone else. You think I come here to harass you? I was just trying to find help to my situation....thanks.

Ok, now I am totally lost! What in the world makes you think that I am being hostile? I consider you a valued associate. Why would I have asked you to be on the RavenNuke(tm) project if I felt otherwise?

Posted: Mon Mar 12, 2007 11:15 pm

I see a lot of :smiley: marks. If anything, Raven was just trying to be light-hearted and helpful.

Posted: Wed Mar 14, 2007 6:57 am

I guess it was a misinterpretation to the statements made such as: Keep us posted (I'm sure you will ) that made me think that way. You can add smileys to sarcastic responses also Evaders99.... Smile

I came to just give a heads up to the fact that when I tried to do something, this is the result I received. Also, maybe a "hey I don't have that problem, but by that error check this" response from someone instead of well I have it installed and it works fine for me. I know there is hundreds of configurations that can cause errors to pop up, but any "helpful" response would have been appreciated.

Raven, I was totally lost also in reading your post as to why the I'm sure you will was mentioned. It struck me odd. Again, must have just been a misinterpretation on my part.

All in all, I can't figure out why one person can download an identical program (xampp) install it on a standard OS without any config. changes (default) settings and have such a wide range of differences. Just doesn't make sense. I will completely remove the xampp install and try it again. My 2.02 Rn version will continue to install without a hitch on it time and time again, but not the 2.10 version, that is why I find it hard to think it is something with the install of xampp, but since all of your guys work ok, it "must" be something here.

Installed the 2.10 public released version on the webhost this morning without a hitch. It was a very pleasant surprise. Smile

Didn't get any of the error messages from the beta version, and didn't have to use any of the work arounds. Have absolutely no idea why, but I'll take it.... Smile

Will be installing a 2.02 version to go thru the upgrade steps with the public released version before attempting my main site upgrade. The way my luck has been going with all of this except the latest install of the 2.10, I am better off going that route.

Posted: Sun Mar 18, 2007 3:46 pm

FireATST wrote:

Raven, I was totally lost also in reading your post as to why the I'm sure you will was mentioned. It struck me odd. Again, must have just been a misinterpretation on my part.

It is/was meant as a tongue-in-cheek humorous comment. I knew you have no problem expressing yourself and that's what I meant by it. Case closed Wink

Posted: Sun Mar 18, 2007 5:57 pm

okey dokey... Smile

Posted: Tue Mar 20, 2007 8:35 am

Follow up...I uninstalled the xampp from my system. (you would think this would be a simple process, but not so much in my case, go figure!) The un-install procedure left behind some apache and mysql objects that did not allow a complete removal of xampp. After a day of searching xampp forums and doing as others had done, FINALLY was able to completely remove it from my system.

I then proceeded to install the 1.6.0 version that is out now. It completed and I then went and installed the R210 locally, and to my great surprise, it installed completely and without hesitation. I still am not sure as to why, but by the looks of xampp forums, it is a problem with many systems, a faulty installation occurs. It appears to be with the Windows version mostly, and to do with the apache and mysql installs. Oh well, at least it appears to be working correctly now.... Smile

So far this install looks to have been completed correctly. Will continue to keep my fingers crossed that all continues to go well.

Posted: Tue Mar 20, 2007 10:52 am

Thanks for the update Wink