41
trabis
Re: Ok, I'm DONE with Smartsection
  • 2010/6/19 20:07

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Quote:

chefry wrote:
Well, I've got almost 10,000 articles, and unfortunately another 13,000 to import from WRAPS.

With these continual problems, I've come to realize that Xoops just can't handle a site as big as mine.

And I haven't got a clue how to hack Publisher to try and see if it gets rid of the problems. :(

Unfortunately, I'll have to build a new site with Joomla


There are sites 10 times bigger then yours running fine with XOOPS. I don't see how using Joomla will make your life easier since you still have to come up with a migration script.

42
Peekay
Re: Ok, I'm DONE with Smartsection
  • 2010/6/19 22:50

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


I'm not actually sure what WRAPS is, but if you export that data and your existing Smartsection tables as CSV you might find Navicat (Free) useful to field-map the data into new MySQL application tables. Although you are probably going to have to split the categories from the articles, so a fair bit of work may be required. As trabis says, you may need to get someone to create a bespoke migration script for you.

To be honest, I think that 23,000 articles is a quantity that most 'News' type modules are unlikely to manage well, on Xoops or Joomla. I would post that exact number on the Joomla forum first to see what they might recommend.

I still think CBB could deal with it, provided the SQL import was error-free, but whatever software you choose, I wouldn't try to import the data all in one go!
A thread is for life. Not just for Christmas.

43
chefry
Re: Ok, I'm DONE with Smartsection
  • 2010/6/20 7:07

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


Quote:

trabis wrote:
There are sites 10 times bigger then yours running fine with XOOPS. I don't see how using Joomla will make your life easier since you still have to come up with a migration script.


Where are they?
What are they?

Can you explain how to the the sql hack so I can try Publisher?

44
ghia
Re: Ok, I'm DONE with Smartsection
  • 2010/6/20 8:01

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


SmartSection has a scaling problem and underperform by allocating huge server resources for large recordsets (>5000).
There seems also a bug that can wipe out the permissions for categories.

45
rgauci
Re: Ok, I'm DONE with Smartsection
  • 2010/6/22 12:56

  • rgauci

  • Not too shy to talk

  • Posts: 173

  • Since: 2007/8/31


I have installed your latest svn copy of Publisher on a new installation and found the following fatal errors so far:

1) Clicking on the MakePdf icon gives this error:
You did not select a valid article !
and the popup page is stuck there

2) If I need to edit the article from the home page by clicking the pencil icon, the submit.php page comes up but once edited and clicked on the edit button this error follows:
Ar Error occured! your article was not submitted!

I have cleaned all caches from the data folder just incase

Thanks
Ray
Be Set FREE!

46
underdog
Re: Ok, I'm DONE with Smartsection
  • 2010/6/22 16:59

  • underdog

  • Just popping in

  • Posts: 44

  • Since: 2007/6/21


Quote:
Ar Error occured! your article was not submitted!

Did you turn on the debug error messages.
In either the "Error" tab or the "Queries" tab you'll probably see the error that really occurred.

47
rgauci
Re: Ok, I'm DONE with Smartsection
  • 2010/6/22 18:20

  • rgauci

  • Not too shy to talk

  • Posts: 173

  • Since: 2007/8/31


I had debug on and it did not pick up any errors.
Be Set FREE!

48
trabis
Re: Ok, I'm DONE with Smartsection
  • 2010/6/22 18:23

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


You need to look at errors in the redirection page. You should hit the stop button on your browser and look to the debug messages. There is also extra debug info in "extra" tab. Look there to see if some setting is missing.

49
rgauci
Re: Ok, I'm DONE with Smartsection
  • 2010/6/22 19:10

  • rgauci

  • Not too shy to talk

  • Posts: 173

  • Since: 2007/8/31


Hi Trabis

I cannot see any debug errors. Also I noticed that in this last Publisher svn copy I download there are missing files from the previous version.

ray gauci
www.maltasport.com
Be Set FREE!

50
trabis
Re: Ok, I'm DONE with Smartsection
  • 2010/6/22 19:34

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


For pdf error(fixed on svn):
line 27
$item_page_id = $itemid = PublisherRequest::getInt('page', -1);
should be
$item_page_id = PublisherRequest::getInt('page', -1);

The edit error I cannot reproduce.

Login

Who's Online

148 user(s) are online (89 user(s) are browsing Support Forums)


Members: 0


Guests: 148


more...

Donat-O-Meter

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

Latest GitHub Commits