Hi Alec,
I've copied this to the pagetool-user list as well, others there may=20
have further suggestions. Do a "reply to all" when replying to send any=20=
reply back to the list and to me :-)
On 28 Feb 2004, at 18:07, Alec Meiklejohn wrote:
> I understand that if anyone is still handling pagetool development and=20=
> support it is you.
Support is hopefully more of a community thing. I only have limited=20
time for Pagetool related matters.
> I'm writing because I am having a serious problem with my site - I am=20=
> not sure if it is a pagetool problem or something to do with the site=20=
> setup. The site was set up by Allison at mediajumpstart, but the folks=20=
> there do not want to get into providing support, and have referred me=20=
> to the pagetool community. There doesn't seem to have been any=20
> activity there (pagetool) for a few months, so I am not sure of the=20
> status of that but thought I would give this a shot. (I registered on=20=
> the developer list around three weeks ago, but never received a=20
> response - that is why I am writing you directly)
You should have received an automated response I think. If you didn't=20
maybe try registering again. The pagetool-user list might be a better=20
option for user support, the pagetool-devel list is more for discussion=20=
of future development of Pagetool....... I don't have access to the=20
admin side of the pagetool-devel list, Jamie does. So I can't tell you=20=
if you are subscribed or not I'm afraid.
> Basically, I am having a problem interacting with mysql tables that I=20=
> set up within my organization's mysql database.=A0 I added an event=20
> calendar to the site, which worked for a while, but now I am unable to=20=
> retrieve any records from that table - no events show up. I also set=20=
> up a categorized news archive, which works by linking a "category"=20
> table to the "pt_core_news" table through the "news_id" field.=A0 The=20=
> category table is also one I set up and interacted with using php=20
> mysql functions. Again this worked fine for several months, but now I=20=
> am unable to retrieve any records from the category table, so the=20
> archive doesn't work.=A0 There was an indication of something odd from=20=
> the beginning. The site also uses=A0 phpMyAdmin 2.4.0,
They are up to 2.5.2 or maybe even higher now.
> and none of the changes I have made using the php mysql functions=20
> have ever shown up in phpMyAdmin. If I created the table using=20
> mysql_query, the table would not show up in phpMyAdmin, even though I=20=
> could access it using the functions - add records, retrieve records,=20=
> list field names, etc..=A0 If I created the table using phpMyAdmin the=20=
> table name would show up there, but any changes I made using the=20
> functions would not. If I added a record, it would not show up through=20=
> phpMyAdmin.=A0 So both tables were shown as having 0 rows in =
phpMyAdmin=20
> even though I was adding records (new events, categories for news=20
> articles) for weeks, and retrieving them through the pagetool=20
> interface using php programs I added to the site.=A0 Now, there =
appears=20
> to be 0 rows in reality - since I cannot access anything or get any=20
> listing of records from either table.
> =A0
> I'm not sure if this is a pagetool problem, but then I don't=20
> understand how it is happening at all. I am probably going to have to=20=
> move the site to a host of my own, which is going to be pretty=20
> laborious (I am new to all this, and have been learning php and mysql=20=
> on the fly), but I thought I would see if you or someone could give me=20=
> some insight into what is going on here, or where else I could go to=20=
> learn more about it.
>
Bit difficult to work out what's happening here without seeing the code=20=
you used from within Pagetool to create and work with the additional=20
tables. =46rom the above description it suggests to me that possibly you=20=
haven't specified in your code which database to use, and the tables=20
have been created in a database other than the Pagetool one. MySQL has=20=
a 'test' database by default, readable and writeable by all users.=20
Maybe your extra tables were in fact created in the 'test' database=20
(I'm guessing big time here), which would work fine, until someone else=20=
played around with the 'test' database and deleted your records and=20
tables.
Does the code you wrote give any MySQL errors which might give a hint=20
to any problems. If you have access to the MySQL logs there might be=20
information there that'll help you work out what's going on.
> =A0
> Thanks for whatever you are able to do,
HTH
> =A0
>
Come back to the list and let us know if you work out what's happened.=20=
It might benefit someone else in the Pagetool community in the future=20
who experiences similar problems.
If you can give further information, example code, error logs and so=20
on, we may be able to help some more.
--=20
Cheers,
d a v e
|