Start with error..

SQL error

dexe	#1 2009-12-08 02:46
Members	Hi. I have a problem with MySQL. Fatal error: SQL error: Unknown column 'page_' in 'order clause' Why? I just installed latest version of cotonti-0.6.5! I found the problem on the start page after trying to enter subcategories. There someone who can tell me why cerned? I saw that others have the same problem but there are few clear answers. Thanks

pieter	#2 2009-12-08 02:59
Team Thanked: 9 tijden	have you added the right sql-file? Maybe give us a link to the site. ... can we help you ...

Yusupov	#3 2009-12-08 03:38
Contributors Thanked: 28 tijden	Check the settings from news plugin.

dexe	#4 2009-12-08 04:16
Members	OK The problem was in changing the name of news. Not switch automatically in news-plug-in (setings) when it is changed. Thank you. Another question.. The pach must be installed manually or are already included with the new version? In Mysql files .. .. because I have many files in the sql folders, as: patch-0.0.1-0.0.2, patch-125-n-0.0.1 .. And folders /updates/0.0.2 - 0.6.3 ecc..

Kort	#5 2009-12-08 04:43
Administrators Thanked: 223 tijden	patches are for upgrades only. use cotonti-0.6.3.sql for a fresh install SED.by - создание сайтов, разработка плагинов и тем для Котонти

dexe	#6 2009-12-08 06:40
Members	Yes, I have already done so. Thank you. Added 4 days later: Another question :-) How i can add polls on section - page.php or list.php example.. I tried but without success, I do not understand the structure still.. Dit bericht is bewerkt door dexe (2009-12-13 02:29, 15 jaren ago)

activebiz	#7 2009-12-14 09:27
Members	same here - I also don't understand. I did a fresh install with the latest version download. Used the 6.3 sql file to load it in in phpadmin, loaded correct [no errors given], but, I get fatal error that a table coton.sed_config does not exist. my db name is coton. So, where do I need to fix this? And - yes, updating is another confusing thing. I installed many scripts but never had to update a db manually. I don't know enough about db's. Plus, whoch one do I need to use with a clean 6.05 install? am assuming that it should be the one in the 6.05 folder/latest update sql file, or does it have to be the patch file? I looked through all the videos too - there is nothing really explained for someone that does not have the know-how to manually create or update db's. And with my luck - no one is around sunday evening.:( Appreciate help - thank you. where is it written that all our dreams must be small ones...

activebiz

#7 2009-12-14 09:27

Members

same here - I also don't understand. I did a fresh install with the latest version download. Used the 6.3 sql file to load it in in phpadmin,
loaded correct [no errors given], but, I get fatal error that a table coton.sed_config does not exist.
my db name is coton. So, where do I need to fix this?
And - yes, updating is another confusing thing. I installed many scripts but never had to update a db manually. I don't know enough about db's. Plus, whoch one do I need to use with a clean 6.05 install?
am assuming that it should be the one in the 6.05 folder/latest update sql file, or does it have to be the patch file?

I looked through all the videos too - there is nothing really explained for someone that does not have the know-how to manually create or update db's.

And with my luck - no one is around sunday evening.:(

Appreciate help - thank you.

where is it written that all our dreams must be small ones...

pieter	#8 2009-12-14 16:04
Team Thanked: 9 tijden	see: http://www.cotonti.com/forums.php?m=posts&q=5063&n=last#bottom ... can we help you ...