News character limit?

Raven · Posted: Sun Oct 26, 2003 8:27 am

This sounds like you may have added a mod that has altered the stories table or the authors table and nuke doesn't know about the alteration. Is that possible? Compare your authors and stories schema to the virgin 6.9 schemas. See if there's a column mismatch.

TheosEleos · Posted: Sun Oct 26, 2003 8:30 am

You mean the database or the php files?

Can textpad compare?

Raven · Posted: Sun Oct 26, 2003 8:32 am

Schemas are the database layouts. Use phpMyAdmin and look at the structure of those tables. Then, look at the SQL that was used to create those tables that came in the sql folder of the 6.9 distribution.

TheosEleos · Posted: Sun Oct 26, 2003 8:36 am

Is there an sql query I can run on the database to compare? I have the sql that came with 6.9.

Raven · Posted: Sun Oct 26, 2003 8:38 am

Just eyeball it. You're comparing 2 small files (authors and stories - sql) to phpmyadmin (database). SQL queries don't run against files.

TheosEleos · Posted: Sun Oct 26, 2003 8:44 am

In nuke_stories

hometext text, (is what 6.9 install is)

hometext text Yes NULL (what I have)

Is that it?

TheosEleos · Posted: Sun Oct 26, 2003 8:50 am

Here is a screenshot for ya. I'm sorry, Raven, this is confusing me a little. Sad

Raven · Posted: Sun Oct 26, 2003 8:52 am

Compare the ENTIRE table structure to ensure that you have the same number of columns in each. What usually happens is that you add a mod that adds a column to a table but doesn't add the logic to the nuke files. or, you restore some base nuke files for one reason or another and those tables are still altered and so the same effect takes place. The fact that you were working and now aren't points to this type explanation.

TheosEleos · Posted: Sun Oct 26, 2003 8:59 am

Would it work to dump both those tables and re-create them? I'm getting desperate here! Laughing

Raven · Posted: Sun Oct 26, 2003 9:04 am

I see that you have 21 fields. This is not the default install. You are using my display order hack. Do you still have the files installed or did you restore the originals when Frogger was helping you? Try dropping ONLY THAT FIELD, not the table. Check the checkbox field display order, in phpMyAdmin, and click the DROP button at the bottom of the display.

TheosEleos · Posted: Sun Oct 26, 2003 9:07 am

Well have mercy! That was it.

I figured nuke would just ignore that field. I want to use your hack though. Is it not compatable with 6.9?

Raven · Posted: Sun Oct 26, 2003 9:07 am

After dropping that field, you will need to restore the following original files

admin.php
admin/modules/stories.php
modules/News/index.php

or it still will not work.

TheosEleos · Posted: Sun Oct 26, 2003 9:10 am

I had already done that thinking your hack was not working for 6.9. I just figured that the old files would not try to access your addition to the table and work fine. I did not know the table had to be an exact match.

I did a test news post and it worked just fine.

I want your hack though! Very Happy

Raven · Posted: Sun Oct 26, 2003 9:10 am

AFAIK it is. But, if you installed other mods that touched those files, then it could have been in conflict. When did you install the ordering mod? Just when it stopped working?

Raven · Posted: Sun Oct 26, 2003 9:12 am

Anytime you uninstall anything, you have to look at the original install package and undo everything that is in that package. The sql piece was the piece that you missed Wink

TheosEleos · Posted: Sun Oct 26, 2003 9:26 am

I installed just a couple of days ago. I had not tried to post a story since the 15th though.

I know for sure I have not installed any other stories mods though. I have not looked into it. I just like being able to order them.

TheosEleos · Posted: Sun Oct 26, 2003 9:27 am

Raven wrote:

Anytime you uninstall anything, you have to look at the original install package and undo everything that is in that package. The sql piece was the piece that you missed Wink

So I am learning! Laughing

Raven · Posted: Sun Oct 26, 2003 9:30 am

OK, I will put it on my list of 'to-do's to check it out for 6.9

TheosEleos · Posted: Sun Oct 26, 2003 9:32 am

Thanks!

I am sure that list is small, right? Laughing