Welcome to Geeklog, Anonymous Saturday, April 20 2024 @ 04:24 am EDT

Geeklog Forums

Modifying mysql_tableanddata.php


julianna

Anonymous
Hi.

I'm trying to create a distribution of Geeklog for use specifically by artists. For this, I want to have a modified version of the mysql_tableanddata.php file with some pre-loaded static pages, a pre-loaded event, and a modified welcome note.

The when I try to create the database with the modified mysql_tableanddata.php file, I get the following error:
1136: Column count doesn't match value count at row 1

I have checked the code a few times, and the counts seem to match. Does anyone mind taking a look at my modifications to make sure I'm not missing something really obvious?

snip (modified):
Text Formatted Code

#
# e-eAsel.org modified welcome-note
#

$_DATA[] = "INSERT INTO {$_TABLES['stories']} (sid, uid, draft_flag, tid, date, title, introtext, bodytext, hits, numemails, comments, related, featured, commentcode, statuscode, postmode, frontpage, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon) VALUES ('welcome', 2, 0, 'General', NOW(), 'Welcome to Geeklog!', '<p>Welcome to the <a href="http://www.e-easel.org">e-eAsel</a> distribution of <a href="http://www.geeklog.net">Geeklog</a> for the maintenance of an artist's website.</p>rr<p>Please take the time to read everything in the <a href="docs/index.html">docs directory</a>. Geeklog now has enhanced, user-based security.  You should thoroughly understand how these work before you run a production Geeklog Site.</p>rr<p>Because this distribution has been created for the maintenance of a site, the login feature has been "hidden". Please go to http://www.yourwebsite.com/users.php to login. The default account information is:</p>r<p>Username: <b>Admin</b><br>rPassword: <b>password</b></p>rr<p><b>And don't forget to change your password after logging in!</b></p>rr<p>To create a new account, go to http://www.yourwebsite.com/admin/user.php (the <i>Users</i> link in the Admins Only section after you log in).rr</p><p>You can delete this article after you have logged into your new site.</p>', '<br>', 100, 1, 0, 0, '<a href="http://www.e-easel.org">e-eAsel</a>n<a href="http://www.geeklog.net">Geeklog</a>n<a href="docs/index.html">docs directory</a>', 1, 1, -1, -1, 0, '1999-11-30 00:00:27', 'html', 1, 0, 2, 3, 3, 2, 2, 2) ";

 


snip (new):
Text Formatted Code

#
# Creating Static Pages for About The Artist and Contact - added by e-eAsel.org
#

$_DATA[] = "INSERT INTO {$_TABLES['staticpage']} (sp_id, sp_uid, sp_title, sp_content, sp_hits, sp_date, sp_format, sp_onmenu, sp_label, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon, sp_centerblock, sp_tid, sp_where, sp_php, sp_nf, sp_inblock) VALUES ('aboutheartist', 2, 'About The Artist', '<p>This is where you would put information about yourself. You can change the title and ID of this page after loggin into the site as an administrator.</p>', 3, NOW(), 'allblocks', 1, 'About The Artist', 2, 14, 3, 2, 2, 2, 0, 'none', 1, 0, 0, 1) ";
$_DATA[] = "INSERT INTO {$_TABLES['staticpage']} (sp_id, sp_uid, sp_title, sp_content, sp_hits, sp_date, sp_format, sp_onmenu, sp_label, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon, sp_centerblock, sp_tid, sp_where, sp_php, sp_nf, sp_inblock) VALUES ('contact', 2, 'Contact Information', 'You can either add your contact information as text or attach an image by editing this page after logging in as the administrator.', 3, 'NOW()', 'allblocks', 1, 'Contact', 2, 14, 3, 2, 2, 2, 0, 'none', 1, 0, 0, 1) ";

#
# Creating sample event - added by e-eAsel.org
#
$_DATA[] = "INSERT INTO {$_TABLES['events']} (eid, title, description, postmode, datestart, dateend, url, hits, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon, address1, address2, city, state, zipcode, allday, event_type, location, timestart, timeend) VALUES ('2006030508004748', 'Sample Event', 'This is a sample event. You can delete/edit this, and add more in the "Events" section after logging in as an administrator.', 'html', '2011-01-01', '2011-01-01', '', 2, 2, 7, 3, 2, 2, 2, '1 Recognition Lane', '', 'Big City', 'NY', '', 1, 'Art Exhibition', 'Prestigious Gallery', '08:00:00', '08:00:00') ";

 


I pulled the values by exporting the data in myPHPadmin, and added a backslash before the double-quotes.

Thanks.

Julianna
 Quote

julianna

Anonymous
I got it. I completely mucked up the order for the welcome note.
 Quote

All times are EDT. The time is now 04:24 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content