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. XOOPS general usage questions 
  4.  / Retrieving articles from database
Register
11
Peekay
Re: Retrieving articles from database

  • 2010/6/22 13:17

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


If you Google

Quote:
mysql error 1170

it appears to be a known problem. This website has a solution if you can understand how to implement it.

I'm at work at present so cannot read through it fully at the moment. I'll take a closer look later.

A thread is for life. Not just for Christmas.
12
Catzwolf
Re: Retrieving articles from database

  • 2010/6/22 13:47

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


To fix this, remove the last line of the table:

KEY: Search (hometext/bodytext)

And also the ',' from the line above that one ( 'KEY: uid(uid),' or you will get another error.

Basically, if you get that error again, just look for a key that matches up with the error and remove it.

Bad fix for a bad bug.
13
ghia
Re: Retrieving articles from database

  • 2010/6/22 15:46

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Or change it to:
KEY search (hometext(450),bodytext(450))

This will not impair functionality during testing.
14
Wonderfish1
Re: Retrieving articles from database

Quote:
Or change it to: KEY search (hometext(450),bodytext(450)) This will not impair functionality during testing.


What do I use to make this change?

Thanks,
Tim
15
ghia
Re: Retrieving articles from database

  • 2010/6/22 22:56

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


An editor?
16
Peekay
Re: Retrieving articles from database

  • 2010/6/23 0:00

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


You can edit SQL files in any text editor. Context is free and pretty good.

http://www.contexteditor.org/
A thread is for life. Not just for Christmas.
17
Wonderfish1
Re: Retrieving articles from database

If I can edit the sql file in an editor, I can also extract the text that I was originally after with an editor.

No need to load the database into anything.

That was all I originally needed to know. I have extracted the necessary text now. Thanks to all those that helped.


Tim
18
madDan
Re: Retrieving articles from database

  • 2010/6/23 11:39

  • madDan

  • Not too shy to talk

  • Posts: 105

  • Since: 2010/1/6 1


Ah I thought you wished to restore the articles back into the site DB.

my mistake.
« 1 (2)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

140 user(s) are online (92 user(s) are browsing Support Forums)

Members: 0

Guests: 140

more...

Donat-O-Meter

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

Latest GitHub Commits