Unable to edit data sheets

[Marc van Arc]

When I tried to edit the new Batasio data sheets just now - synonyms and authors have become my thing more or less - I got a fatal error of some kind (sorry, forgot to copy it) resulting in the fact that I can't enter the sheets.
Perhaps a bug or no permission due to the new set up??

[MatsP]

Yup, got:

Fatal error: Call to undefined function phpbb_hash() in /home/planetca/public_html/catelog/data_sub.php on line 45

[Jools]

I know, it's broken. Bascially the page used the forum authentication to grant access and it is horribly more complex than before. It may mean that I require to make the data_sub page part of the forum. It's now my priority thing to work on.

Jools

[bronzefry]

When I tried to edit the new Batasio data sheets just now - synonyms and authors have become my thing more or less - I got a fatal error of some kind (sorry, forgot to copy it) resulting in the fact that I can't enter the sheets.
Perhaps a bug or no permission due to the new set up??

You can edit the data sheets, Marc?
Amanda

[Jools]

Nobody can use the facility at present, I am working on it, I reckon I might have it done in a day or two but certainly by Saturday night.

I have the security authentication working (at least for mods, it might take a bit longer to get it to authenticate down to the cat-elog data team group level). What I now have to do is move all the code out of the old format and into the new forum format. That bit is pretty time consuming.


Jools

[matsp-nonmod]

Ehm, no, no one can do that at the moment. You, Marc, Jools or anyone else are able to do it - because the login function is broken. [Technically, Jools can update the database by other means, but the "Edit this data sheet" doesn't work].

--
Mats

[Jools]

Progress continues getting this fixed. Unfortunately I made a mistake when testing the new forum, I thought the old data submission page would work with the new forum but it doesn't actually work in terms of allowing or refusing access to the correct users. This basically means I need to entirely rewrite the data submission page for the new forum. Well, almost entirely, I can re-use the database updating bits but as there are bugs in there to do with extra slashes appearing when they shouldn't I'm going to address that as well.

You can't actually do anything with this yet, but you can see progress as I work on it over the weekend by clicking on the edit data sheet link.

Jools

[Marc van Arc]

You can't actually do anything with this yet, but you can see progress as I work on it over the weekend by clicking on the edit data sheet link.

Yes, there's something happening. The "Fatal error" is gone and I now get "Data submission is restricted".
Keep up the good work and pls take your time.

[Jools]

Try that now? I've just finished getting it to successfully check if the user is a member of the "cat-elog data subs" group. It will allow edit of several fields it WILL NOT yet do anything with the database. You can however click on submit and it will put some output up on the screen only.

I would appreciate if you could confirm this works for you.

Jools

[Jools]

Some good news.

The data submission feature is open for business again! I have not yet added all the fields in, but the rest of it is all there. When all fields are in I will posted again and move this post into the "resolved" forum.

Jools

[Marc van Arc]

I got this:

General Error
SQL ERROR [ mysqli ]

Unknown column 'synonym_status1' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

I took it this field was already added?

[Jools]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

I took it this field was already added?

No, this was a bug in my new code. I have changed it now and so you should be able to add synonyms now.

Jools

[Marc van Arc]

Got the same message again.

[Jools]

Got the same message again.

Sorry, forgot to upload template as well as new code. I've tried it now (online as opposed to my test site) and it appears to work.

Jools

[Marc van Arc]

Could this part be of any importance: 'synonym_author1' in 'field list' [1054]

As you already noticed, adding authors to valid species is no problem. I just did the Batasio dayi without problems.
I also just added 1 synonym without author. That went alright too.
But for some reason the system doesn't take authors in the synonyms box (yet). Just tried and got the above error message.

[Jools]

Could this part be of any importance: 'synonym_author1' in 'field list' [1054]

As you already noticed, adding authors to valid species is no problem. I just did the Batasio dayi without problems.
I also just added 1 synonym without author. That went alright too.
But for some reason the system doesn't take authors in the synonyms box (yet). Just tried and got the above error message.

Yes, there was a problem with this field which has now been corrected.

Jools

[bronzefry]

All set, Jools!
Thanks,
Amanda

[Marc van Arc]

Yes, seems to work fine. Both synonyms of Batasio dayi are now complete.
Btw: I like the fact that the extra log in is no longer necessary.

[Jools]

Yes, seems to work fine. Both synonyms of Batasio dayi are now complete.

There's a problem at my end, but it's not to do with the submission page or the way it was entered which is fine. Leave it with me to fix.

Btw: I like the fact that the extra log in is no longer necessary.

One good thing of all this upgrading is it refocusses me on things that could be improved...

Jools

[Jools]

This is now complete.

Jools