XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / News problem!!
Register
1
ReySolar
News problem!!

  • 2005/4/19 21:00

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi!
I have a News problem. Don't know if it's connected, but after I installed and uninstalled News2 and Alter8news, and installed Newscategory, I cannot post anymore with News. Now it says "error". Anybody knows what's wrong with it and how to fix it?
Thanks

ReySolar
2
ReySolar
Re: News problem!!

  • 2005/4/19 22:20

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi again!!!
A relationed question: anybody knows if it's possible to uninstall and install again the News module or, eventually,to update version 1.2 to 1.3 preserving all the posts?
Thanks

ReySolar
3
jdseymour
Re: News problem!!

On the second question, export your tables in the database prior to uninstalling. when you uninstall a module the tables and all content are removed from the database.

The first question, I have no idea. Have you tried any of the debugging options to get more information on the error?
4
ReySolar
Re: News problem!!

  • 2005/4/19 23:18

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi jdseymour!
Thanks very much!
In the debugging options there is no more information about this error. And, instead of export my tables in the database, I decided -for more simplicity- to copy and paste in word the few posts that I sent. Now I'll uninstall and reinstall News 1.2 or probably I can install directly News 1.3. Is that right?

ReySolar
5
jdseymour
Re: News problem!!

Yes, copy and paste is good for clean install of News 1.3.

Good luck.

Let us know how you make out.
6
ReySolar
Re: News problem!!

  • 2005/4/19 23:30

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Hi again!

I've just uninstalled News 1.2 and tried to reinstall it to check if it's all OK, but I found two errors: 1) In the uninstalling process, it says "ERROR: Could not drop table xoops_categories". I think that I have to delete it manually 'cause I installed previously News categories and it's not exactly a module that you can uninstall; and 2) When I tried to reinstall the News 1.2 module, it says the following:

You have an error in your SQL syntax near 'catname varchar(40) NOT NULL default '', PRIMARY KEY (storyid), KEY idxstor' at line 1
Unable to install news.

Any idea?

Thanks


ReySolar
7
jdseymour
Re: News problem!!

Only the first one, sorry. Yes you need to manually drop that table.

The syntax error I do not know about. Drop the table and try again. I would go straight with news 1.3.
8
ReySolar
Re: News problem!!

  • 2005/4/19 23:49

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Thanks!!!
I'll try and let you know...

ReySolar
9
ReySolar
Re: News problem!!

  • 2005/4/20 0:06

  • ReySolar

  • Not too shy to talk

  • Posts: 181

  • Since: 2005/2/2 1


Anyone have any idea about the syntax error:

You have an error in your SQL syntax near 'catname varchar(40) NOT NULL default '', PRIMARY KEY (storyid), KEY idxstor' at line 1
Unable to install news.


Thanks!

ReySolar

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

175 user(s) are online (150 user(s) are browsing Support Forums)

Members: 0

Guests: 175

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits