Forums

I can edit records in the frontend, and I can add/edit them in the back-end, but I can't save them in the frontend. The buttons work and it looks like the info is being saved, but it never ends up in the database. Anybody have any ideas?

Hi kavaXtreme,

may be your table doesn't have a primary key or the field with the key is not properly loaded at the frontend or one of your table fields names doesn't have a good name ?

Max

I'm not sure I was clear in my first post, but basically the issue is that I can't create new records in the front-end, only the back-end. The table seems to have a primary key (in phpmyadmin under table structure under indexes there is a keyname called Primary that contains the id field). What has me stumped is that all the other add/edit functionality works. I can edit records just fine in the frontend using the same code. This is the only exception.

Here's the frontend record edit code:

<table style="clear:both;">
  <tr>
    <td>Title:</td>
    <td><input type="text" name="title" size="50" value=""></td>
  </tr>
  <tr>
    <td>Description:</td>
    <td><textarea name="description" rows="10" cols="50"></textarea></td>
  </tr>
  <tr>
    <td>Author:</td>
    <td><input type="text" name="author" value=""></td>
  </tr>
  <tr>
    <td>Volume:</td>
    <td><input type="text" name="volume" value=""></td>
  </tr>
  <tr>
    <td>Month:</td>
    <td><input type="text" name="month" value=""></td>
  </tr>
  <tr>
    <td>Year:</td>
    <td><input type="text" name="year" value=""></td>
  </tr>
  <tr>
    <td>Page Number:</td>
    <td><input type="text" name="pgstart" value=""></td>
  </tr>
  <tr>
    <td>Section:</td>
    <td><input type="text" name="section" value=""></td>
  </tr>
</table>
<input type="hidden" name="id" value="">

Permissions are identical for all frontend functionality. Should I be adding something to any of the other fields in the Front Permissions tab?

did you add the new record line text ?

Max

On the General tab under "New Link Code"? Yes, I have some text and html in that field. It opens up the form and everything seems to work right, but after saving the new record it doesn't get added to the database.

may be the permissions are set wrong, check ALL groups, try to be logged in to the site frontend when you test.

Did you add the {new_record} text to the header ?

Cheers
Max

Thanks for your time. I had somebody more knowledgeable than myself fix it for me. I'm not sure what they did, but in any case it works now.