Last modified: 2010-10-04 14:35:50 UTC
Hi, I have followed all the instructions to install Semantic MediaWiki. When I try to enter anything in a page and click on Save Changes, then I get the following error: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SMW::updateRedirects". MySQL returned error "1146: Table 'wikidb.bpsmw_redi2' doesn't exist (localhost)". Please let me know what am I doing wrong, the bp before the smw_redi2 is the prefix for my mediawiki. Thanks, /Balbinder
This table is created during setup (the installation step where you either go to Special:SMWAdmin and press "Initialise or upgrade tables" or run the maintenance script "SMW_setup.php" on your server). Could you please execute one of those steps and post the output here?
(In reply to comment #0) > Hi, > I have followed all the instructions to install Semantic MediaWiki. When I try > to enter anything in a page and click on Save Changes, then I get the following > error: > A database query syntax error has occurred. This may indicate a bug in the > software. The last attempted database query was: > (SQL query hidden) > from within function "SMW::updateRedirects". MySQL returned error "1146: Table > 'wikidb.bpsmw_redi2' doesn't exist (localhost)". > Please let me know what am I doing wrong, the bp before the smw_redi2 is the > prefix for my mediawiki. > Thanks, > /Balbinder Hi Marcus, I had already done that setup and tried one more time and this is the message I get. Setting up standard database configuration for SMW ... Selected storage engine is "SMWSQLStore2" (or an extension thereof) Setting up table `BPsmw_ids` ... ... table exists already, checking structure ... ... column smw_id is fine ... column smw_namespace is fine ... column smw_title is fine ... column smw_iw is fine ... column smw_sortkey is fine ... table `BPsmw_ids` set up successfully. Please let me know if you need more information on this. Cheers, /Balbinder
This is not the normal behaviour. The output starts correctly, but it should report about a number of further tables and finish with the message "The storage engine was set up successfully." It might help if you could provide the version numbers of SMW and MediaWiki, and of any other extensions that you currently use.
(In reply to comment #3) > This is not the normal behaviour. The output starts correctly, but it should > report about a number of further tables and finish with the message "The > storage engine was set up successfully." > > It might help if you could provide the version numbers of SMW and MediaWiki, > and of any other extensions that you currently use. > Hi Marcus, I am currently on MediaWiki 1.14 & Semantic version 1.4.2 (as per the Release notes). I have one other extension installed (Tasks) and this was after I installed Semantic. Thanks, /Balbinder
Strange, nothing unusual here. I am not sure what the problem could be. Two more things might help: (1) Can you also provide some details (versions) on your Web server, DBMS, and operating system? (2) Can you try running the script "SMW_setup.php", found in the maintenance directory below the SemanticMediaWiki directory? For this you need command line access to your server, and the PHP command line client. Then simply type "php SMW_setup.php" from within the directory. Maybe the output of this is more helpful.
I still cannot reproduce this bug. Since there has not been any further activity since 4 months, I am closing it now as WORKSFORME.
I just tried installing Semantic Media Wiki, and am encountering the same exact issue. MediaWiki 1.16.0 PHP 5.3.0 (apache2handler) MySQL 5.1.36-community-log Semantic MediaWiki (version 1.5.2) Clicking the first button in Special:SMWAdmin gives this output: Setting up standard database configuration for SMW ... Selected storage engine is "SMWSQLStore2" (or an extension thereof) Checking table `smw_ids` ... Table already exists, checking structure ... ... field smw_id is fine. ... field smw_namespace is fine. ... field smw_title is fine. ... field smw_iw is fine. ... field smw_sortkey is fine. ... done. When trying to save an entry, I get the following error: ארעה שגיאת תחביר בשאילתה לבסיס הנתונים. שגיאה זו עלולה להעיד על באג בתוכנה. השאילתה האחרונה שבוצעה לבסיס הנתונים הייתה: (שאילתת ה־SQL מוסתרת) מתוך הפונקציה "SMW::updateRedirects". בסיס הנתונים החזיר את השגיאה "1146: Table 'wikidb.smw_redi2' doesn't exist (localhost)". מקור: http://viki/wiki/index.php/%D7%A2%D7%9E%D7%95%D7%93_%D7%A8%D7%90%D7%A9%D7%99 (that's Hebrew for the same issue...)
Managed to overcome this issue: For whatever reason, my mediawiki installation has three wikiuser users, under different hosts: %, localhost and localhost.localdomain. After granting all three of them CREATE, ALTER, DROP privileges, the script ran to its end, and saving entries now works.