Affilistore Error

[Lee_Owen]

Tweet

'Got error 127 from storage engine'

How do I get rid of this, hosting company tells me it's software related.

Cheers
Lee

[purple]

I believe affilistore has a forum on their site who could answer query

[Lee_Owen]

You believe correct, but the password system doesn't work and I still can't get in from the first time I signed up and I don't get a response from emails, which is ok, it was free, so that's why I'm asking here.

Thanks, so anyone got the same and solved it?

Cheers
Lee

[simhd]

I don't use Affilistore but I have had this error before in one of our MySQL tables, when one of our tables corrupted. It was quite a large table with over 1 million records.

To fix it I just ran a REPAIR TABLE on the corrupt table. I traced the cause of the corruption to an REPLACE INTO sql statement, which MySQL 5.0 didn't particularly like for some unknown reason.

If the same table keeps corrupting it is probably a problem with one of the SQL statements.

This problem never happened with MySQL 4.0, and we only got this error at random occurrences when we had upgraded the system to MySQL 5.0

Simon

[Lee_Owen]

Thanks, I'll probably just do a reinstall tonight, I already moved across the old but the same error showed which is why I thought it was the hosting, I'll delete everything and the database and do a new one.

Cheers
Lee

[John Jupp]

Ooh! We nearly got the same problem with our stuff. I think (may be wrong) the Affilistore script isn't written for particular versions of MySQL as you have to keep on top of stuff owing to MySQL and PHP version upgrades. We noticed this when writing our stuff and did a mod rewrite to correct this. So our stuff works on most versions including the new releases which webhost providers are upgrading to. We recently had to rewrite the setup file for a client who had an old version of MySQL as the new rewrite was too advanced for it.

[William]

Another problem i discovered with Affilistore is when you refresh your product feeds.

Each single product is allocated a prodID number and if you had say a feed of say 2000 products then the product URLs would be for example
http://www.mysite.co.uk/affilistore/...000000001.html to http://www.mysite.co.uk/affilistore/...000002000.html

But when you refresh your feed the URLs would then be
http://www.mysite.co.uk/affilistore/...000002001.html to http://www.mysite.co.uk/affilistore/...000004000.html

The first 2000 single product page urls are now empty pages with errors on them. If you where to refresh this feed once a day within a week you would have 14000 pages with errors on them. I do not think the likes of google would appreciate pages appearing then disappearing then reappearing with a different url.

Affilistore has the potential to be a very good easy to use script but not with the problem i mentioned.

It is interesting to see others either using or contemplating using Affilistore. Are you all aware of this problem? Maybe one of you have a solution for this problem. I actually purchased Affilistore and raised this problem with Affilistore but they could not come up with a solution and very soon after i raised the problem they started giving the script away for free.

I would really be interested if someone has a solution to this problem.

William

[Lee_Owen]

With my earlier problem I just did a new database, re your refreshing problem, I don't refresh, I put in a new datafeed each time.

I just wish I knew an easy way of doing search engine friendly urls for free - if anyone has this priviliged information please do private message me on my 24 hour customer service hotline dedicated to people with priviliged information about search engine friendly urls for free or you can contact me on domaini@hotmail.co.uk

Cheers
Lee

[purple]

I just clicked permalinks on affilistore and then they are simple urls or have I missed the point?

[William]

Affilistore will rewrite your links to permalinks giving you links like this:
http://www.mysite.co.uk/affilistore/...000123456.html

Im not sure but possibly Lee means the links being rewritten to something like this:
http://www.mysite.co.uk/shop/productname.html

[Lee_Owen]

Yes I'm on about product title in the url, there's a way of doing it but I aint been told yet. If any merchant knows and I use them, perhaps they'd like to point me in the right direction or supply the code.

Cheers
Lee

[purple]

Affilistore will rewrite your links to permalinks giving you links like this:
http://www.mysite.co.uk/affilistore/...000123456.html

Im not sure but possibly Lee means the links being rewritten to something like this:
http://www.mysite.co.uk/shop/productname.html

I forgot about the ugly individual product pages, yes it would be good to have a rewrite for individual products.