Smiley table missing from database

[PopLife]

Hey everyone,
Once again I need help. I have been having problems with my smileys for ages.

For example. When attempting to change my smiley set-

Code Select Expand

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's')' at line 3
File: /home/wtntenni/public_html/forums/Sources/Subs.php
Line: 617

(I have updated to SMF 1.1 since first receiving the error, so therefore, it is a database problem. Not an Subs.php problem)

AND THE MAJOR PROBLEM. When installing ocPortal-

Code Select Expand

An error has occurred

Unfortunately a query has failed [SELECT * FROM smf_smileys ] [Table 'wtntenni_forums.smf_smileys' doesn't exist]
Here is the stack-trace
File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 282
Function 'get_html_trace'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 156
Function 'clean_exit'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 517
Function 'db_query'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 278
Function '_db_query'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 501
Function 'forum_query'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 354
Function 'forum_query_select'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 238
Function '_smile'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 494
Function 'comcode_to_tempcode'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 238
Function 'insert_lang'

File '/home/wtntenni/public_html/pages/modules/banners.php'
Line 59
Function 'lang_code_to_default_content'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 172
Function 'install'
Class 'module_banners'
Type '->'

File '/home/wtntenni/public_html/install.php'
Line 3884
Function 'reinstall_module'

File '/home/wtntenni/public_html/install.php'
Line 3137
Function 'step_6'


How can I just install EVERYTHING TO DO WITH SMILEY'S again.

[PopLife]

*BUMP
I'm going to get some sleep now

[PopLife]

So no-one knows how to fix this problem? 

[[Unknown]]

Are you sure your prefix is smf_?

-[Unknown]

[PopLife]

I didn't even notice. Thanks. Where can I check the prefix of my forums?

[PopLife]

Yes. smf_ is the correct prefix

[PopLife]

Well, as I thought all along, there is no smileys table.

I don't really understand, but what I happen to believe is that ocPortal is attempting to change all "smf" prefixes to "ocp2"

When I run the wtntenni_forums MySQL repair from Cpanel, it says this exactly

Code Select Expand

wtntenni_forums.cpg133_albums                      OK
wtntenni_forums.cpg133_banned                      OK
wtntenni_forums.cpg133_categories                  OK
wtntenni_forums.cpg133_comments                    OK
wtntenni_forums.cpg133_config                      OK
wtntenni_forums.cpg133_ecards                      OK
wtntenni_forums.cpg133_exif                        OK
wtntenni_forums.cpg133_filetypes                   OK
wtntenni_forums.cpg133_pictures                    OK
wtntenni_forums.cpg133_temp_data                   OK
wtntenni_forums.cpg133_usergroups                  OK
wtntenni_forums.cpg133_users                       OK
wtntenni_forums.cpg133_votes                       OK
wtntenni_forums.ocp2_attachment_refs               OK
wtntenni_forums.ocp2_attachments                   OK
wtntenni_forums.ocp2_authors                       OK
wtntenni_forums.ocp2_banners                       OK
wtntenni_forums.ocp2_blocks                        OK
wtntenni_forums.ocp2_cache                         OK
wtntenni_forums.ocp2_cached_comcode_pages          OK
wtntenni_forums.ocp2_config                        OK
wtntenni_forums.ocp2_db_meta                       OK
wtntenni_forums.ocp2_db_meta_indices               OK
wtntenni_forums.ocp2_dotw                          OK
wtntenni_forums.ocp2_f_categories                  OK
wtntenni_forums.ocp2_f_custom_fields               OK
wtntenni_forums.ocp2_f_db_meta                     OK
wtntenni_forums.ocp2_f_db_meta_indices             OK
wtntenni_forums.ocp2_f_emoticons                   OK
wtntenni_forums.ocp2_f_forum_group_access          OK
wtntenni_forums.ocp2_f_forum_tracking              OK
wtntenni_forums.ocp2_f_forums                      OK
wtntenni_forums.ocp2_f_group_members               OK
wtntenni_forums.ocp2_f_groups                      OK
wtntenni_forums.ocp2_f_member_custom_fields        OK
wtntenni_forums.ocp2_f_member_known_login_ips      OK
wtntenni_forums.ocp2_f_members                     OK
wtntenni_forums.ocp2_f_moderator_logs              OK
wtntenni_forums.ocp2_f_multi_moderations           OK
wtntenni_forums.ocp2_f_poll_answers                OK
wtntenni_forums.ocp2_f_poll_votes                  OK
wtntenni_forums.ocp2_f_polls                       OK
wtntenni_forums.ocp2_f_posts                       OK
wtntenni_forums.ocp2_f_read_logs                   OK
wtntenni_forums.ocp2_f_topic_tracking              OK
wtntenni_forums.ocp2_f_topics                      OK
wtntenni_forums.ocp2_f_warnings                    OK
wtntenni_forums.ocp2_group_category_access         OK
wtntenni_forums.ocp2_group_zone_access             OK
wtntenni_forums.ocp2_gsp                           OK
wtntenni_forums.ocp2_https_pages                   OK
wtntenni_forums.ocp2_import_id_remap               OK
wtntenni_forums.ocp2_modules                       OK
wtntenni_forums.ocp2_seedy_changes                 OK
wtntenni_forums.ocp2_seo_meta                      OK
wtntenni_forums.ocp2_sessions                      OK
wtntenni_forums.ocp2_sp_list                       OK
wtntenni_forums.ocp2_text                          OK
wtntenni_forums.ocp2_translate                     OK
wtntenni_forums.ocp2_values                        OK
wtntenni_forums.ocp2_zones                         OK

The first few are from coppermine. As you look down, there is absolutely no smiley tables.

Thankyou for your health

[xenovanis]

These are all tables in your database? There are missing some more, then. Do you have any idea whether this is a know problem with ocPortal or whether it is compatible with SMF 1.1 Beta 3?

To create a smileytable, run this in mySQL:

Code Select Expand


DROP TABLE IF EXISTS `smf_smileys`;

CREATE TABLE `smf_smileys` (
  `ID_SMILEY` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(30) NOT NULL default '',
  `filename` varchar(48) NOT NULL default '',
  `description` varchar(80) NOT NULL default '',
  `smileyRow` tinyint(4) unsigned NOT NULL default 0,
  `smileyOrder` tinyint(4) unsigned NOT NULL default 0,
  `hidden` tinyint(4) unsigned NOT NULL default 0,
  PRIMARY KEY (`ID_SMILEY`)
) TYPE=MyISAM;


Note that you can change the prefix after the CTEATE TABLE command.

[PopLife]

I don't think it is an issue with ocPortal. I think that something may have happened with SMF (mod conflict?)

Where do I enter this command?

[xenovanis]

In phpMyAdmin, select the database and click the 'SQL' tab at the top of your screen. Copy the code into the textfield and click 'Go'.

[PopLife]

Code Select Expand


Warning: uksort(): The argument should be an array in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 360

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: uksort(): The argument should be an array in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 360

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: uksort(): The argument should be an array in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 360

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482

Warning: Invalid argument supplied for foreach() in /home/wtntenni/public_html/install.php(3985) : eval()'d code on line 482
Fail: SELECT ID_GROUP,groupName FROM smf_membergroups

ocPortal installer, step 6 of 8
An error has occurred

Unfortunately a query has failed [SELECT ID_GROUP,groupName FROM smf_membergroups ] [Table 'wtntenni_forums.smf_membergroups' doesn't exist]
Here is the stack-trace
File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 282
Function 'get_html_trace'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 156
Function 'clean_exit'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 517
Function 'db_query'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 278
Function '_db_query'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 501
Function 'forum_query'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 458
Function 'forum_query_select'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 21
Function '_forum_get_usergroup_list'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 181
Function 'forum_get_usergroup_list'

File '/home/wtntenni/public_html/pages/modules/banners.php'
Line 67
Function 'add_specific_permission'

File '/home/wtntenni/public_html/install.php(3985) : eval()\'d code'
Line 172
Function 'install'
Class 'module_banners'
Type '->'

File '/home/wtntenni/public_html/install.php'
Line 3884
Function 'reinstall_module'

File '/home/wtntenni/public_html/install.php'
Line 3137
Function 'step_6'


OK, now that the table is in the database, I get these errors. I don't know why I even bothered with ocPortal Too impatient waiting for Enigma...

[PopLife]

Sorry to bump this topic again. It's just important that I get this up and running again.

[xenovanis]

Oh, I'm sorry. I thought you were going to break with ocPortal. Misunderstanding. 

There is something I don't understand. I've read a bit about ocPortal and I understand it is altering the tableprefixes of SMF. The tablestructure you posted earlier contains only prefixes with 'wtntenni_forums.ocp2', so your prefix for the smileys should be wtntenni_forums.ocp2_smileys'. Could that be the problem?

[PopLife]

No xenovanis that wasn't it, I found the problem. I am also missing the smf_membergroups table!!!

I don't know what details I should input when creating the membergroups table. Can you please help me out with that?

What I don't understand, is ocPortal screwing with my tables? Surely I would have noticed if the membergroups table was missing all along?

[xenovanis]

No xenovanis that wasn't it, I found the problem. I am also missing the smf_membergroups table!!!

I don't know what details I should input when creating the membergroups table. Can you please help me out with that?

What I don't understand, is ocPortal screwing with my tables? Surely I would have noticed if the membergroups table was missing all along?

I'm curieus, what was the problem?

Anyway, to create the membergrouptable, use this:

Code Select Expand


CREATE TABLE `smf_membergroups` (
  `ID_GROUP` smallint(5) unsigned NOT NULL auto_increment,
  `groupName` varchar(80) NOT NULL default '',
  `onlineColor` varchar(20) NOT NULL default '',
  `minPosts` mediumint(9) NOT NULL default -1,
  `maxMessages` smallint(5) unsigned NOT NULL default 0,
  `stars` tinytext NOT NULL default '',
  PRIMARY KEY (`ID_GROUP`),
  KEY `minPosts` (`minPosts`)
) TYPE=MyISAM;


I know I read something about oc changing the prefixes yesterday, but I can't find it anymore and don't have time to do an extended search. Let you know as I've found it. 

[PopLife]

I got the installtion working (thanks to xenovanis) but now the portal index returns-

Code Select Expand

Fail: SELECT * FROM smf_members WHERE (ID_MEMBER='1') LIMIT 1

This error reccurrs to the page bottom.