1
teibaz
Xoops 2.2.3: smarty read error: block_...
  • 2006/1/7 9:57

  • teibaz

  • Not too shy to talk

  • Posts: 103

  • Since: 2004/6/13


So,
just fresh installed XOOPS 2.2.3 and.. Smarty could not read block resources..

Windows
Apache 1.3.34
PHP 4.4.1
MySQL 4.1.15

perhaps because of MySQL version (i guess) there is an error in one query, which should return source, but return false.. I lost a hour while i found it :/ Problem is in html\install\sql\mysql.structure.sql file 486 line:

KEY tpl_tplset (tpl_tplset,tpl_file(10))


I was bored to find out why this line gets false, but if we delete this line it should work perfect and then blocks will be visible again.

Cheers,
teibaz

2
killertomato
Re: Xoops 2.2.3: smarty read error: block_...

Hi,

You're suppose to delete the 'install' folder after installing XOOPS so which process is that you deleted "KEY tpl_tplset (tpl_tplset,tpl_file(10))"? Is it before you install XOOPS and then it won't have any problem afterwords?

3
teibaz
Re: Xoops 2.2.3: smarty read error: block_...
  • 2006/1/9 6:25

  • teibaz

  • Not too shy to talk

  • Posts: 103

  • Since: 2004/6/13


i recomend to do this before installation. In other way you can delete this INDEX condition in phpMyAdmin

4
killertomato
Re: Xoops 2.2.3: smarty read error: block_...

Teibaz,

Well, it's my fault but I didn't delete it before reinstalling it. Again, while I was adding/deleting modules it happned again. So frustrating.

Before I start it over again, could you kindly please let me know how to delete 'tpl_tplset' from phpMyAdmin page? I'm such a monkey when it comes to it. I found 'tpl_topset' in phpMyAdmin but afraid of doing something to it. Do I need to "DROP" it? If I need to "CHANGE" it, what do I need to set it for?

Thanks for your time.

5
teibaz
Re: Xoops 2.2.3: smarty read error: block_...
  • 2006/1/12 20:02

  • teibaz

  • Not too shy to talk

  • Posts: 103

  • Since: 2004/6/13


OK, lets start step-by-step

open phpMyAdmin (pma)
select your database
select '{xoops_prefix}_tplfile' table
now you can see tables structure
at the bottom of page there is block 'Indexes' take a look at it.
There should be three rows and the row where in Field is value 'tpl_file(10)' you should delete.

Then it should everything work propertly

Cheers

6
killertomato
Re: Xoops 2.2.3: smarty read error: block_...

I deleted it but still the same problem... hmm.

There is another solution just posted at
https://xoops.org/modules/newbb/viewtopic.php?topic_id=43338&forum=39
so I might try this as well... it looks like there are a lot of people having the same problem. Hopefully it'll be fixed or developers are aware of it.

7
killertomato
Re: Xoops 2.2.3: smarty read error: block_...

my bad, I finally got it.

had to 'update' system and any modules that were getting smarty error message back.
not it's fixed! Thanks you very much!

Login

Who's Online

309 user(s) are online (101 user(s) are browsing Support Forums)


Members: 0


Guests: 309


more...

Donat-O-Meter

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

Latest GitHub Commits