this is bare minimum :)

Look at any block and the bID and copy that field into your db.xml.

These things have to be tracked somewhere and that is where it all starts.

-Scott

hi ScottC;

Acctually i made a view in mysql and wana just retrieve data and show it? so still givingme error.
mysql error: [1347: 'seraj.ticker' is not BASE TABLE] in EXECUTE("ALTER TABLE Ticker MODIFY COLUMN cID INTEGER")
this is the db.xml
<?xml version="1.0"?>

<schema version="0.3">
<table name="Ticker">


<field name="cID" type="I">
</field>

<field name="cPath" type="X2">
</field>

<field name="cvName" type="X2">
</field>

</table>

</schema>
any help plz

I am having the same problem. I also only need to retrieve data and disply it without doing any saving. but it won't work without db.xml. And if i only add bID as a field, all the fields from my table (the table i need to retrieve data from) except bID will be deleted.

I guess that the only solution to this problem right now, is to make this view block create a new table, that will remain empty and unused at all time.

The minimum for a block db.xml is a table matching the $btTable variable in the block controller. That table needs to have minimumn a bID which needs to be the index, and I discovered that additionally it needs at least one more field (even if you're not using it) so for my blocks that don't need any database access my minimum db.xml looks like this:


Hope that helps!

yes, that is my conclusion as well.. thank you for your response.. :)